CICA 1994 April/CICA Shareware for Windows CD-ROM (Walnut Creek CD-ROM)(April 1994).ISO/win3/access/access_l.exe/ACC9303.TXT

Text File | 1993-12-28 | 266KB | 5,766 lines

=========================================================================
Date:         Mon, 1 Mar 1993 11:53:35 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      NO SUBJECT

Please subscribe my i.d. to your list about access information.
Thanks
=========================================================================
Date:         Mon, 1 Mar 1993 13:32:00 EDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Phil Comeau <[e-mail]>
Subject:      Re: Tab move sequence in Form.
In-Reply-To:  <no.id>; from "Undetermined origin c/o Postmaster" at Feb 26,
              93 4:32 pm

> So, are other people coming to the conclusion that MS Access is a hodged
> together POS like I am?

Hard to say. Perhaps if you let us know what kind of hodged together
POS you are, we could make a valid comparison.

Sorry. Couldn't resist.

Phil Comeau, Software Kinetics Ltd.
[e-mail]
=========================================================================
Date:         Mon, 1 Mar 1993 13:35:04 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      Re: NO SUBJECT
In-Reply-To:  Message of Mon, 1 Mar 1993 11:53:35 -0500 from <S-DESJ@UMINN1>

I would be glad to do so, but I need a name to go with the user id to make
Listserv happy.  :)  You can subscribe yourself, if you wish, by sending
a message to [e-mail] with the single line

SUBSCRIBE S-DESJ@UMINN Your Name

Either way is fine; like I say, I just need a real name to go with the id.

Thanks,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 1 Mar 1993 13:50:14 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "NATHAN BRINDLE" <[e-mail]>
Subject:      apology

Sorry about that last message--I didn't look closely enough at the
header and replied to the list.  It's Monday...

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 1 Mar 1993 14:00:52 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      DDE manipulation of Access

Can anyone tell me how to open an Access database via the DDE interface
described in the Access readme file? At present I can retrieve data from
such a database (if I know the names of the tables within it) with DDE
values like the following:

     Topic:utility;sql select * from employees in nwind.mdb;
     Item:  all , or data, or ... as required.

Thanks in advance!

Elizabeth Klaver
[e-mail]
Dept. of English
Southern Illinois University, Carbondale
=========================================================================
Date:         Mon, 1 Mar 1993 17:58:38 -0800
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      printing reports (macro limitations)

Does anyone know if there is any way for me to write a macro that will print a
report to a file?

In my effort to produce an ASCII input file as a report from Access, I've
gotten to the point where I can produce the report and manually print it to a
file using a generic driver to generate ASCII (non-Postscript) data, suitable
for input to the next stage of my processing pipeline.  However, when I try to
automate this by putting it into a macro, I can find no way to get past the
print Dialog box.  I need to use it rather than the Print Action because the
latter specifies no parameters for enabling "print to file."

I tried the SendKeys? Action to send %l (ALT-l) and a file name, but Access
just sat there with the Print Dialog box, and would get no further.  Any ideas?
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
[e-mail]        5686 First Court, West Linn, OR 97068

I went to a museum where they have all the heads and arms of the statues
in the other museums
--Steve Wright
________________________________________________________________________________
=========================================================================
Date:         Tue, 2 Mar 1993 07:15:35 PDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Mark Barnet (Business Enter. Syst. Tech)" <[e-mail]>
Subject:      RE: printing reports (macro limitations)

If I use the Setup from the report, and specify the generic printer
driver assigned to FILE: then all I get when I run the report is a
dialog box asking for the filename. It sounds like you are getting more
than that. Possibly because you have the generic printer driver
assigned to LPT1: rather than to FILE:.
----------
|From:  <netmail![e-mail]>
|To: Multiple recipients of list ACCESS-L
<[e-mail]>
|Subject: printing reports (macro limitations)
|Date: Monday, March 01, 1993 5:58PM
|
|Does anyone know if there is any way for me to write a macro that will print a
|report to a file?
|
|In my effort to produce an ASCII input file as a report from Access, I've
|gotten to the point where I can produce the report and manually print it to a
|file using a generic driver to generate ASCII (non-Postscript) data, suitable
|for input to the next stage of my processing pipeline.  However, when I try to
|automate this by putting it into a macro, I can find no way to get past the
|print Dialog box.  I need to use it rather than the Print Action because the
|latter specifies no parameters for enabling "print to file."
|
|I tried the SendKeys? Action to send %l (ALT-l) and a file name, but Access
|just sat there with the Print Dialog box, and would get no further.
Any ideas?
|_____________________________________________________________________
__________
|Robert Reed                     Home Animation Ltd.             503-656-8414
|[e-mail]        5686 First Court, West Linn, OR 97068
|
|I went to a museum where they have all the heads and arms of the statues
|in the other museums
|--Steve Wright
|_____________________________________________________________________
__________
|
|
=========================================================================
Date:         Tue, 2 Mar 1993 08:58:01 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         randy legeai <[e-mail]>
Subject:      Mailing Labels

I've been having a strange problem printing mailing labels
from Access on my trusty old Panasonic KX-P1180 dot matrix
printer.  If I set up labels using the formwizard, they look
fine on the screen, but when they print on the DMP, the top
of the first label doesn't print.  Instead, the first label
starts with the second line, and all labels are then thrown
off by that amount.  Then, there is a form-feed before the last
label prints.  I have selected the correct Avery label, and
cannot figure out what else could be causing this problem.
I had a similar problem when I experimented with Approach
some time ago.  Any suggestions would be appreciated.
--
Randall Legeai                             [e-mail]
Federal Agency Affairs / Ctr. Bioenv. Research      Phn: 504/865-5758
327 Gibson Hall, Tulane University                  Fax: [phone]
New Orleans, Louisiana 70118-5698
=========================================================================
Date:         Tue, 2 Mar 1993 10:17:47 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Calculated field problem

I am having a problem which looks an awful lot like a bug in Access to
me.

I have a database with a text field called [First Name]. When I print a
report with the cell value being either First Name or [First Name], then
the report is fine. However if I make the cell a calculated field (i.e.
=[First Name]), then the field in the report is printed as #error. The
reason It is all so fishy is that if I substitute another identically
defined field for First Name it works in all of the cases.

Has anyone seen this before? Does anyone have a work around? I just want
to string the first and last names together in the form of
=[First Name]&" "&[Last Name]

Len Wanger
[e-mail]
San Diego Supercomputer Center
=========================================================================
Date:         Tue, 2 Mar 1993 11:08:12 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Gene Marshall <[e-mail]>
Subject:      Re: Calculated field problem
In-Reply-To:  <[e-mail]>; from "[e-mail]" at
              Mar 2, 93 10:17 am

>
> I am having a problem which looks an awful lot like a bug in Access to
> me.
Nop!

> ... the field in the report is printed as #error.

Hi Len,

As a new user, I get this a lot. The problem (with me anyway) is the
first field in the 'properties' list. The control needs to be a new
(unique) name. You are probably leaving it as FirstName. Here access
wants to use the data in that field, yet you are defining it to be a
(potentially) different value. Just change that first field (or control)
name from FirstName to something like FirstName_calculated.

Have fun...
Gene

+----------------------------------------------------------------------------+
|Gene Marshall                        /-/-/             email: genem@.hp.com |
|Hewlett Packard Co., MS 42UN           |                 Tel: [phone]  |
|Software Technology Division (SWT)     |                 Fax: [phone]  |
|11000 Wolfe Road                       |              [e-mail] |
|Cupertino, CA 95014                   /|\       Bay Area: 147.39+ / 223.96- |
+----------------------------------------------------------------------------+
=========================================================================
Date:         Tue, 2 Mar 1993 12:28:36 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Morris Myers <[e-mail]>
Subject:      Re: Mailing Labels

----- Begin Included Message -----
I've been having a strange problem printing mailing labels
from Access on my trusty old Panasonic KX-P1180 dot matrix
printer.  If I set up labels using the formwizard, they look
fine on the screen, but when they print on the DMP, the top
of the first label doesn't print.  Instead, the first label
starts with the second line, and all labels are then thrown
off by that amount.  Then, there is a form-feed before the last
label prints.  I have selected the correct Avery label, and
cannot figure out what else could be causing this problem.
I had a similar problem when I experimented with Approach
some time ago.  Any suggestions would be appreciated.
----- End Included Message -----


I've seen this same bug using MicroSoft Word mail merge to print
labels. I don't have a work-around. I suspect the problem may be
inherent in Microsoft 'scripts' that print labels. If I find a way
around the problem I'll post it. If anyone else figures out how to
make Access work right I will try to apply that solution to MS Word.
=========================================================================
Date:         Wed, 3 Mar 1993 08:38:04 MDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         "Brian Keeler (403) - 471-8623" <[e-mail]>
Subject:      Calculated field problem
In-Reply-To:  note of 93-03-02 18:55

to string the firstname and last name together use the following command:

  ="|[firstname]| |[lastname]|"     this will also eliminate spaces etc.
                                    from the firstname field.
                                    I used this in a REPORT option

Brian Keeler    (403) - 471-8623
Application Services Coordinator
Information Services Division
domain: [e-mail]
=========================================================================
Date:         Wed, 3 Mar 1993 09:03:27 PDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Mark Barnet (Business Enter. Syst. Tech)" <[e-mail]>
Subject:      RE: Calculated field problem

The field name on the report/form must not equal the source name if you
expect to use a function as the source.
eg.
given field in database called [Field]
given form field called [Field] with source called [Field] or Field ==> success
given form field called [Field] with source called =[Field] ==> failure
(recursive reference to itself)
given form field called [F1] with source called [Field] or Field or
=[Field] ==> success (no recursiveness here!)

----------
|From:  <netmail![e-mail]>
|To: Multiple recipients of list ACCESS-L
<[e-mail]>
|Subject: Calculated field problem
|Date: Tuesday, March 02, 1993 10:17AM
|
|I am having a problem which looks an awful lot like a bug in Access to
|me.
|
|I have a database with a text field called [First Name]. When I print a
|report with the cell value being either First Name or [First Name], then
|the report is fine. However if I make the cell a calculated field (i.e.
|=[First Name]), then the field in the report is printed as #error. The
|reason It is all so fishy is that if I substitute another identically
|defined field for First Name it works in all of the cases.
|
|Has anyone seen this before? Does anyone have a work around? I just want
|to string the first and last names together in the form of
|=[First Name]&" "&[Last Name]
|
|Len Wanger
|[e-mail]
|San Diego Supercomputer Center
|
|
=========================================================================
Date:         Wed, 3 Mar 1993 09:22:40 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Calculated field problem
In-Reply-To:  Your message of "Wed,
              03 Mar 93 09:03:27 PDT." <[e-mail]>

> The field name on the report/form must not equal the source name if you
> expect to use a function as the source.
> eg.
> given field in database called [Field]
> given form field called [Field] with source called [Field] or Field ==>
 success
> given form field called [Field] with source called =[Field] ==> failure
> (recursive reference to itself)
> given form field called [F1] with source called [Field] or Field or
> =[Field] ==> success (no recursiveness here!)

Thanks to the various Access sages who pointed out the error in my ways! This
was indeed the problem. I also appologize to the Access team for implying that
there was a bug. I do believe this problem might be a good candidate of this
group ever puts together a FAQ list (and maybe for Microsoft to add to the
Q&A file). Several other people also mentioned to me that they had experienced
this problem.

Len Wanger
=========================================================================
Date:         Wed, 3 Mar 1993 12:47:40 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan C. Brindle" <[e-mail]>
Subject:      FAQ list
In-Reply-To:  Message of Wed, 3 Mar 1993 09:22:40 -0800 from <[e-mail]>

If someone wants to develop a FAQ list for ACCESS-L, I will try to get
disk space to store it on.  My life is already busy enough...:)...but
if all I have to do is store it, I think it's something we should offer.

Anyone interested in producing such a compilation should contact me directly
via private mail.

By the way, I think the bouncing mail situation has cleared up.  I haven't
gotten any errors back for two days, meaning (I hope) that the Internet
domain list here at INDYCMS has been updated.  Fingers are crossed.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 3 Mar 1993 13:49:16 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Sunday EVERYDAY <[e-mail]>
Subject:      Re: FAQ list
In-Reply-To:  <no.id> from "Nathan C. Brindle" at Mar 3, 93 12:47:40 pm

>
> If someone wants to develop a FAQ list for ACCESS-L, I will try to get
> disk space to store it on.  My life is already busy enough...:)...but
> if all I have to do is store it, I think it's something we should offer.
>
> Anyone interested in producing such a compilation should contact me directly
> via private mail.
kinda funny.  I just downloaded the FAQ from Microsoft, so i'll be
uploading them soon. (by the end of this week).  :)
(yes, i'm too lazy to respond personally, nate.:)
>
> -----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
> Nathan C. Brindle, Student Activities Office
> Indiana University Purdue University Indianapolis
> Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
> List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
> Internet:    [e-mail] or [e-mail]
> ------------------------------------------------------------------------------
>
-jon
=========================================================================
Date:         Wed, 3 Mar 1993 12:28:02 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      FoxPro list?

Does anyone know of a list/forum for FoxPro?

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Wed, 3 Mar 1993 13:17:42 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Tony Tam <[e-mail]>

Hi, I need help in implementing pop up forms in ACCESS.  What I want to do
is to have a Combo box for a list of customers in a 'Inventory' form and let the
user either type in a name or select it from the list.  If the
customer is not in the list, the user can pop up another form to add a customer.
But I want to have the pop up form to add the customer that the user typed and I
want the pop form to be modal.  Since in the customer form, there might be a
 'Zip' code
Combo Box that the user can pop up and add a zip code and so on.

The problem is that when I open up the form as modal, the code doesn't continue
 until
the modal form is closed.  This customer form may be called from any number of
 other forms
so I don't want any code on the 'customer' form to reference specify forms.

Any ideas?


 ---------------------
 Tony <having a lot of fun> Tam :)      | [e-mail]
=========================================================================
Date:         Wed, 3 Mar 1993 13:39:00 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Tony Tam <[e-mail]>
Subject:      Re: Tab move Sequence in form

>Unfortunately disabling it is not going to suit the purpose.  I want
>to have a button that operates that isn't in the tab order.  I guess
>I'll have to wait for the next version or try something that someone
>else suggested in private mail, that is, put the button in the header
>or footer of the form.

What about changing the OnExit property of the control that has the
tab order before your button to skip to the next control?

Write a ACCESS function called GotoToControl() and set the OnExit property
of the previous control to be '=GotoControl("NextControl")

--------------------------------------------
Function GotoToControl(ctrlName As String)

  DoCmd GotoControl ctrlName    // I think the name of the Macro is GotoControl

End Function

-----------------------------------------------------------------------------
Tony <having a lot of fun> Tam :)      | [e-mail] (Internet)
=========================================================================
Date:         Wed, 3 Mar 1993 18:24:04 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Tab move Sequence in form
In-Reply-To:  Your message of "Wed, 03 Mar 93 13:39:00 PST."

>What about changing the OnExit property of the control that has the
>tab order before your button to skip to the next control?
>
>Write a ACCESS function called GotoToControl() and set the OnExit property
>of the previous control to be '=GotoControl("NextControl")
>
>--------------------------------------------
>Function GotoToControl(ctrlName As String)
>
>  DoCmd GotoControl ctrlName    // I think the name of the Macro is GotoControl
>
>End Function
>
>-----------------------------------------------------------------------------
>Tony <having a lot of fun> Tam :)      | [e-mail] (Internet)

But how do you know if you're exiting the control in a backward or forward
direction? That was my only problem with this approach.

Joe
=========================================================================
Date:         Wed, 3 Mar 1993 12:43:37 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Rickey Thomas Tom <[e-mail]>

I hope someone out there can solve the following problem


I have two tables

table1                              table2
    lastName                           firstName      lastName
     tom                                 doug           tom
     john                                doug           john
     jackson                             mathew         john
     wilson

I need an SQL statement which will

1) fetch all lastnames from table1 WHICH ARE NOT in Table2 and the firstname is
   doug

Such a query, when applied to the above will return a list from table1 which
include jackson, wilson. The lastname fields are foreign keys.

In the lastest ANSI SQL standard, I could just use

SELECT lastName * from table1 where lastname not in
       (select lastname from table 2 where firstname = "doug")

It appears that the in() statement in Access does not allow another select
statement (syntax error is posted)


Any help or suggestions would be greatly appreciated. Thank you in advance
=========================================================================
Date:         Wed, 3 Mar 1993 12:46:06 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Rickey Thomas Tom <[e-mail]>
Subject:      help with multi table queries

I hope someone out there can solve the following problem


I have two tables

table1                              table2
    lastName                           firstName      lastName
     tom                                 doug           tom
     john                                doug           john
     jackson                             mathew         john
     wilson

I need an SQL statement which will

1) fetch all lastnames from table1 WHICH ARE NOT in Table2 and the firstname  is
   doug

Such a query, when applied to the above will return a list from table1 which
include jackson, wilson. The lastname fields are foreign keys.

In the lastest ANSI SQL standard, I could just use

SELECT lastName * from table1 where lastname not in
       (select lastname from table 2 where firstname = "doug")

It appears that the in() statement in Access does not allow another select
statement (syntax error is posted)


Any help or suggestions would be greatly appreciated. Thank you in advance

Rick
=========================================================================
Date:         Wed, 3 Mar 1993 19:38:42 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         George Raudabaugh <[e-mail]>

My general question on this, is there a way to do an kind of subselect (or
sub query or nested select - take your pick) in Access?  I've had zero luck
in this and would guess its a FAQ.

GR.

--
George Raudabaugh               Manager/Document Technologies
Information Dimensions, Inc.    [e-mail] (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio  43017             [phone]                     (voice mail)

>From:  IN%"[e-mail]"  "Microsoft Access Databa
 se Discussion List"  3-MAR-1993 19:02:46.69
>To:    IN%"[e-mail]"  "Multiple recipients of li
 st ACCESS-L"
>CC:
>Subj:
>
>I hope someone out there can solve the following problem
>
>
>I have two tables
>
>table1                              table2
>    lastName                           firstName      lastName
>     tom                                 doug           tom
>     john                                doug           john
>     jackson                             mathew         john
>     wilson
>
>I need an SQL statement which will
>
>1) fetch all lastnames from table1 WHICH ARE NOT in Table2 and the firstname is
>   doug
>
>Such a query, when applied to the above will return a list from table1 which
>include jackson, wilson. The lastname fields are foreign keys.
>
>In the lastest ANSI SQL standard, I could just use
>
>SELECT lastName * from table1 where lastname not in
>       (select lastname from table 2 where firstname = "doug")
>
>It appears that the in() statement in Access does not allow another select
>statement (syntax error is posted)
>
>
>Any help or suggestions would be greatly appreciated. Thank you in advance
=========================================================================
Date:         Thu, 4 Mar 1993 02:01:32 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Tab move Sequence in form
In-Reply-To:  <[e-mail]> from
              "[e-mail]" at Mar 3, 93 06:24:04 pm

How about moving this one button to the end of your tab order (you can
group all such buttons there) and then set OnEnter property of the first
one of them to run a macro that sends you to the first object in tab order,
and OnEnter in the last one to send you to the last object.

Dmitry Serebrennikov           [e-mail]
=========================================================================
Date:         Thu, 4 Mar 1993 09:32:36 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Steve Carr <[e-mail]>
Subject:      Searching Subforms

Can I search subform records to filter records in the parent form?  The
documentation says you can't do it, but then elsewhere I've seen examples of
expressions that refer to controls on the subform.

#######################################################################
Join the Progressive Jewish Mailing List (PJML) for an open
discussion.  Send the following message to
[e-mail] or [e-mail]:
              SUB PJML <your first name> <your last name>
Join the Progressive Jewish Activism List (PJAL) for a moderated
discussion.  Send the following message to [e-mail] or
[e-mail] to receive an application:
              SUB PJAL <your first name> <your last name>
#######################################################################

      Steve Carr                         [e-mail]
      Dept. of Radio-TV-Film             512/471-4071
      20903                              fax: [phone]
      University of Texas at Austin
      Austin TX  78712
=========================================================================
Date:         Thu, 4 Mar 1993 09:38:10 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Implementing pop-up forms

On Wed, 3 Mar 1993 13:17:42 PST, Tony Tam wrote:

>Hi, I need help in implementing pop up forms in ACCESS.  What I want to do
>is to have a Combo box for a list of customers in a 'Inventory' form and let th
 e
>user either type in a name or select it from the list.  If the
>customer is not in the list, the user can pop up another form to add a customer
 .
>But I want to have the pop up form to add the customer that the user typed and
 I
>want the pop form to be modal.  Since in the customer form, there might be a
> 'Zip' code
>Combo Box that the user can pop up and add a zip code and so on.

>The problem is that when I open up the form as modal, the code doesn't continue
> until
>the modal form is closed.  This customer form may be called from any number of
> other forms
>so I don't want any code on the 'customer' form to reference specify forms.

I'm not sure I have interpretted your question correctly, but here's a stab
at it.  (I'm  coming from a Visual Basic background, just beginning in Access,
so plz excuse if something doesn't fit quite right.)

Let's say you have an order entry form, on which one control is a combo box
of customer names.  If the user doesn't find the name in the list, he types in
a new name.  Event code for the combo box captures this, and from this point,
you want to put the user into a form for entry of all pertinent customer
data before continuing with order entry.  But other forms in your system
(perhaps invoice preparation, etc.) need to be able to do the same thing -
add a  new customer.

Implement the handling of the New Customer form through a function procedure,
which can be called from any other procedure/form.  The function [let's call
it AddNewCustomer()] pops up the New Customer form as modal to collect the
info.  Set up the function such that you pass it the string of the new name
the user entered.  Have it return a value or string that you can use in the
caller routine to determine whether a new customer was added successfully,
maybe the new customer's ID or name (in final form), or the value False if
the customer was not added successfully.

BTW, if you need a user to enter just one item on a pop-up form, just use
the MsgBox function (not statement).  This would do for something like your
zip code example.

Hope this helps.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Thu, 4 Mar 1993 10:56:38 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Tony Tam <[e-mail]>
Subject:      Re:  Implementing pop-up forms

> > other forms
> >so I don't want any code on the 'customer' form to reference specify forms.
>
> I'm not sure I have interpretted your question correctly, but here's a stab
> at it.  (I'm  coming from a Visual Basic background, just beginning in Access,
> so plz excuse if something doesn't fit quite right.)
>
> Let's say you have an order entry form, on which one control is a combo box
> of customer names.  If the user doesn't find the name in the list, he types in
> a new name.  Event code for the combo box captures this, and from this point,
> you want to put the user into a form for entry of all pertinent customer
> data before continuing with order entry.  But other forms in your system
> (perhaps invoice preparation, etc.) need to be able to do the same thing -
> add a  new customer.
>
> Implement the handling of the New Customer form through a function procedure,
> which can be called from any other procedure/form.  The function [let's call
> it AddNewCustomer()] pops up the New Customer form as modal to collect the
> info.  Set up the function such that you pass it the string of the new name
> the user entered.  Have it return a value or string that you can use in the
> caller routine to determine whether a new customer was added successfully,
> maybe the new customer's ID or name (in final form), or the value False if
> the customer was not added successfully.
>

But the problem is that how do I pass in the customer name that the user
typed into a modal form?

Thanks

 ---------------------
 Tony <having a lot of fun> Tam :)      | [e-mail]
=========================================================================
Date:         Thu, 4 Mar 1993 16:44:24 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Editing Question

Hello, I hope someone has come across of what I am trying to do:
  does any one have a suggestion on what was the intended way to handle a
  situation like following in Access

      I have a form with customer information (address etc.) and do not
      want to let user edit the information accidentally, i.e. I want
      for user to have to press some button before he is allowed to edit
      any of the fields.
      I have implemented this using a button that runs MenuCommand "Editing
      Allowed" (because I didn't find how to do this with just macro commands).
      Thus I have the form come up with editing disabled and then I can toggle
      that with the button.

      My problem is that now I am changing the design and now I will have
      some fields in the header of the form that I *want* user to edit
      (such as search criteria), but my scheme prevents user from changing
      those fields too.

      My question is can anyone think of another way to implement this so that
      I prohibit editing only sertain fields and that I can controll that with
      a button?


Thanks

Dmitry  Serebrennikov                [e-mail]
=========================================================================
Date:         Fri, 5 Mar 1993 09:15:43 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      Re:  Implementing pop-up forms

>But the problem is that how do I pass in the customer name that the user
>typed into a modal form?

On your new customer form, you'll have a text box for the customer's name.
Set the value of that text box to the name which is passed to the function,
BEFORE displaying the form, like:

        frmNewCustomer!txtCustomerName = $NewName

where $NewName is the variable in function's definition.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Fri, 5 Mar 1993 16:57:11 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     Warning -- original Sender: tag was [e-mail]
From:         Ned Logan <[e-mail]>
Subject:      Mailing list

Please unsubscribe me to the ACCESS-L mailing list. I don't have access to
ACCESS any more. Thank you very much.

Ned
=========================================================================
Date:         Sun, 7 Mar 1993 10:11:10 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Tony Tam <[e-mail]>
Subject:      Re:  Implementing pop-up forms

> >But the problem is that how do I pass in the customer name that the user
> >typed into a modal form?
>
> On your new customer form, you'll have a text box for the customer's name.
> Set the value of that text box to the name which is passed to the function,
> BEFORE displaying the form, like:
>
>         frmNewCustomer!txtCustomerName = $NewName
>
> where $NewName is the variable in function's definition.
>

Thanks for all your help.  But either I'm not reading the manual
correctly for Access Basic or you might not that familar with Access.

In order to open a form, we have to use a syntax like:

   OpenForm "FormName", A_NORMAL,..., [A_DIALOG]|[A_NORMAL]|[A_ICON]|[A_HIDDEN]

So if I want to open the form in A_DIALOG, the code would not continue
until the form is closed, which makes sense for a MODAL DIALOG BOX.  But
after I open the form, how do I set the values since the code would not
continue until the form is closed?  Sorry if I'm either not asking the
right question or that I'm missing something.


 ---------------------
 Tony <having a lot of fun> Tam :)      | [e-mail]
=========================================================================
Date:         Mon, 8 Mar 1993 09:13:03 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Toby Rockwell <[e-mail]>
Subject:      Forcing Capital Letters
In-Reply-To:  <[e-mail]>

I had no problem forcing letters in my state and (Canadian) zip code
fields to be all caps (> in format), but when a report is generated to
print out mailing labels, the damned letters revert to lower case.
looking at the output of the underlying query shows upper case as does
the base table.  However entering an individual field to edit it in the
base table does indicate that the stored characters are indeed lower
case.

So how does one force the actual storage of the characters to be upper
case, or alternatively force the output of the report to print as upper case?
=========================================================================
Date:         Mon, 8 Mar 1993 08:47:00 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Forcing Capital Letters

No, you have to specify the '>' as part of the field definition when you
define the table (format field).

Or, you can specify the '>' as part of your report.

Miguel A. Rivera
AT&T Bell Labs.
Naperville, IL. 60563
=========================================================================
Date:         Mon, 8 Mar 1993 10:08:50 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: Forcing Capital Letters
In-Reply-To:  Message of Mon,
              8 Mar 1993 08:47:00 CST from <[e-mail] M>

True.  What he wants can be accomplished by setting the format property
of the text box on the report to ">".  If he wants to have the table field
default to all caps, he needs to set the format property of the field
accordingly.

(I know this is repetetive, but I'm trying to track down a couple of mail
bounces and thought I would chime in.  Sorry...)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 8 Mar 1993 12:25:52 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Toby Rockwell <[e-mail]>
Subject:      ReQuery: Forcing Capital Letters
In-Reply-To:  <[e-mail]>

Perhaps I didn't make my exact requirements clear. '>' alone will
apparently not fulfil my requirements thusly:

>True.  What he wants can be accomplished by setting the format property
>of the text box on the report to ">".

Except that my text reads: [city]&", "&[state]&" "&(etc.) so the entire
text box cannot be set to UpperCase as I only want the State in Uppers.

>If he wants to have the table field
>default to all caps, he needs to set the format property of the field
>accordingly.

Assuming that what is meant here is to simply put a '>' into the format line,
I would have thought that this would work as well.  This was my
original method as it happens.  When one looks at
the table itself, or a subsequent query, the state field will be
"displayed to the screen" as UpperCase.  If, however, the cursor is put
into the state field for editing; the actual text entered in the field
(and the text that is subsequently printed out in the report) is found
to be *still* the same form that it was entered as originally.  In other
words, only the display of the field appears to be affected, not the
underlying data stored in the field.   So, my question remains
=========================================================================
Date:         Mon, 8 Mar 1993 13:04:35 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Toby Rockwell <[e-mail]>
Subject:      Re: Forcing Capital Letters
In-Reply-To:  <[e-mail]>

Mea Culpa, mea maxima culpa
Tough problems yield, little ones fester.
I self-found the solution as I should have before, an in line format
statement:  [city]&", "&format([state],">")&" "(etc.) which works just fine.

I WOULD like to know, why doesn't the actual value in the table get
stores as it is formatted?
=========================================================================
Date:         Mon, 8 Mar 1993 20:58:02 SAT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Trevor D. Rotzien" <[e-mail]>
Subject:      Repetitive display of main form rows in left join

Greetings,

I have just begun to develop Access db's for my colleagues, and would be
enjoying it without reservation, except for one problem:

In a form/subform view, the data from the main row is repeated as many
times as there are matching rows in the subform for that main row. The
form has as it's source a left join query. These redundant rows ONLY
appear in the view, and not in the table.  The fact that the
repetition number is exactly equal to the number of matching rows in the
subform implies to me that the wording of my query is at fault, but I
can't see any obvious problem.

For those of you who are SQLiterate, I'll forward the text of the query
shortly.

Thanks for any and all suggestions!

----------------------------------------------------------------------
trevor d. rotzien         marine science group
k.f.u.p.m. box 118        water resources & environment division
dhahran 31261             the research institute
saudi arabia              king fahd university of petroleum & minerals

email: [e-mail]
office: -966-03-860-4316
----------------------------------------------------------------------
=========================================================================
Date:         Mon, 8 Mar 1993 19:10:57 EDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Steve Miller <[e-mail]>
Subject:      Re: Tab move Sequence in form
In-Reply-To:  <[e-mail]>; from "Revised List
              Processor" at Mar 8, 93 6:39 pm

> Date:         Wed, 3 Mar 1993 18:24:04 -0500
> Reply-To:     "Microsoft Access Database Discussion List"
>               <[e-mail]>
> Sender:       "Microsoft Access Database Discussion List"
>               <[e-mail]>
> From:         [e-mail]
> Subject:      Re: Tab move Sequence in form
> In-Reply-To:  Your message of "Wed, 03 Mar 93 13:39:00 PST."
>
> >What about changing the OnExit property of the control that has the
> >tab order before your button to skip to the next control?
> >
> >Write a ACCESS function called GotoToControl() and set the OnExit property
> >of the previous control to be '=GotoControl("NextControl")
> >
> >--------------------------------------------
> >Function GotoToControl(ctrlName As String)
> >
> >  DoCmd GotoControl ctrlName    // I think the name of the Macro is
 GotoControl
> >
> >End Function
> >
> >-----------------------------------------------------------------------------
> >Tony <having a lot of fun> Tam :)      | [e-mail] (Internet)
>
> But how do you know if you're exiting the control in a backward or forward
> direction? That was my only problem with this approach.
>
> Joe


In order to get around this problem, use a dummy control,
usually an unbound text box. You add this dummy control between
the the last control you want in the tab order and the button,
like this:

   Control_1
   Control_2
   Control_3
   Dummy_Control
   Button_1
   Button_2

Now, set the OnEnter property of the Dummy_Control to a macro
which goes to Control_1. This results in a backwards tab from
Control_3 going to Control_2 and a forward tab going to
Control_1.

The key to this is the Dummy_Control. This has to be a visible
control. However, if you make it really small and put it near the
edge of the form, it isn't visible. Just make sure you remember
where you put it on the form so that you can find it if you need
to.

--
+-------------------------------------------------------+
| Steve Miller                   PictureTel Corporation |
| email: [e-mail]       One Corporation Way    |
| phone: [phone]          Peabody, MA 01960      |
+-------------------------------------------------------+
=========================================================================
Date:         Tue, 9 Mar 1993 07:25:26 SAT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Trevor D. Rotzien" <[e-mail]>
Subject:      Repeated main rows in form/subform

This query is used as the record source for a form/subform:


FROM  Main List, Synonyms,


I want all records in Main List to be displayed once, and any records
matching the join criteria to be displayed in the subform. What I am
getting is a matching record in Main List repeated for as many times
as there are matching records in Synonyms. The matching records in
Synonyms are displayed correctly in the subform.

Comments?

----------------------------------------------------------------------
trevor d. rotzien         marine science group
k.f.u.p.m. box 118        water resources & environment division
dhahran 31261             the research institute
saudi arabia              king fahd university of petroleum & minerals

email: [e-mail]
office: -966-03-860-4316
----------------------------------------------------------------------
=========================================================================
Date:         Tue, 9 Mar 1993 16:30:27 +1000
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Joe Briganti <[e-mail]>
Subject:      changing a report-wizard generated report

How do you make changes to report-wizard generated reports.

For example, say I have created a mailing label report using the
wizard and I used say avery-label 1562 (English) but want to change
it (after I've saved the report) to say 1563?

I've checked the manual and it only refers to changing the formats
of the fields selected etc.

The same would apply to I guess whether you originally selected
"executive" style but then after saving decide you want "ledger" style.

A reference to manual would be appreciated in addition to any help in this
matter.

Thanks in advance.
--
Joe Briganti ( [e-mail] )
Contractual obligations prevent me from speaking on behalf of my employer.
=========================================================================
Date:         Tue, 9 Mar 1993 09:08:17 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      repeated rows in query containing join

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
What you have not done is ensured that a join condition of the type
table1.X=table2.Y is encoded in the query. This is done either by specifying
a relationship or adding it into the WHERE clause.

Select A.b, A.c, B.aa, B.cc
from A,B
where A.b = B.b

When joining a table to another (be it itself a view or anything) this type
of where clause mus be used, if outer join is needed then use the syntax
for that. All  these are also specifiable using the graphical relationship
tool as well.

Anne

Thankyou
===============================================================
=========================================================================
Date:         Tue, 9 Mar 1993 09:46:19 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Gerry Roston <[e-mail]>
Subject:      Help using dynaset within AB

It is my turn to ask for help. I spoke with the tech support folks,
but the answer was not complete. I followed up with the following
(as a Fax) but they never responded. If the following description is
incomplete, please let me know and I will add the additional
required information. Your help is appreciated. (p.s. When I get
this done, I have no problem sharing the results with y'all.)

I have a report, named BibReport, based on a query.  Because of the nature
of the output, I did not use the Report Wizard to create this report,
rather I started with a blank report and added a single, unbound control to
the section.  Looking at the properties, the Record Source for the report
is Search, the Control Name for the single text box is Text1111 and the
Control Source is shown as =OD().

The query, Search, is also quite simple.  The first column sorts the table
based on one of the fields, and the second uses a Like criteria to limit
the records.  Because of the type of application, the query property
Restrict Available Fields is not selected, i.e., I want all fields to
appear in the dynaset.

So, now we must look at OD().  The purpose of this function is to format
the output properly.  Since my table has 25 fields, I am only showing a
simplified version of this module:

Option Compare Database   'Use database order for string comparisons
Option Explicit

Function OD () As String
    Dim ds As Dynaset
    Dim toe, an, au, jnl, kw, mn, note, num, pp, tl, vol, yr As String
    Dim workString As String

    Set ds = Reports!BibReport.Dynaset
    toe = ds![type of entry] 'type of entry, Author and Title are all defined
    au = ds![Author]         'fields in my table, and also in the dynaset
    tl = ds![Title]          '[rest of variable assignments removed for brevity]

    Select Case toe
        Case "Article"
            workString = au & ". " & tl & ". " & jnl & ", "
            If Not IsNull(vol) Then OD = OD & vol
            If Not IsNull(num) Then OD = OD & "(" & num & ")"
            If Not IsNull(pp) Then OD = OD & ":" & pp & ", " Else OD = OD & ": "
            If Not IsNull(mn) Then OD = OD & mn & " "
            OD = OD & yr
            If Not IsNull(kw) Then OD = OD & Chr(13) & Chr(10) & "Keywords: " &
 kw
            If Not IsNull(an) Then OD = OD & Chr(13) & Chr(10) & an
    End Select
    OD = workString
End Function

When I open the report in preview mode, I get a pop-up-window with the
message Couldn't Find field 'type of entry'.  However, this field does
exist in the table, and I assume in the query also because of the query
property mentioned above.  The is not a typographical error as I have tried
this with many of the fields and consistently get the same result.  To try
an figure out what was going on, I found the following routine in The
Language Reference, page 163.

Sub Print_Field_Names ()
    Dim ListSet As Snapshot
    Set ListSet = Reports!BibReport.Dynaset.ListFields()
    ListSet.MoveFirst
    Do Until ListSet.EOF
        Debug.Print ListSet.Name
        ListSet.MoveNext
    Loop
End Sub

I ran this program in the Immediate Window and the result I got was #NULL#.
So, some how, the fields are getting lost.  However, when I print
the value of Reports!BibReport.Dynaset.RecordCount, it prints a value of 18,
which is correct!

Now, if one of you is really up to the challenge, try the following
(but I am certain that it can not be done): In the block of code
shown above, routine OD, figure out how to make certain items appear
in the regular font and part in italic font!
Gerry Roston ([e-mail])    | A man's ethical behavior should be based
Field Robotics Center,          | effectually on sympathy, education, and
Carnegie Mellon University      | social ties; no religious basis is
Pittsburgh, PA, 15213           | necessary.  Man would indeed be in a poor
[phone]                  | way if he had to be restrained by fear and
                                | punishment and hope of reward after death.
The opinions expressed are mine | Albert Einstein
and do not reflect the official |
position of CMU, FRC, RedZone,  |
or any other organization.      |
=========================================================================
Date:         Wed, 10 Mar 1993 11:00:40 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Tony Tam <[e-mail]>
Subject:      changing a report-wizard generated report
In-Reply-To:  Joe Briganti's message of Tue,
              9 Mar 1993 16:30:27 +1000
              <[e-mail]>

>How do you make changes to report-wizard generated reports.

>For example, say I have created a mailing label report using the
>wizard and I used say avery-label 1562 (English) but want to change
>it (after I've saved the report) to say 1563?

>I've checked the manual and it only refers to changing the formats
>of the fields selected etc.

>The same would apply to I guess whether you originally selected
>"executive" style but then after saving decide you want "ledger" style.

>A reference to manual would be appreciated in addition to any help in this
>matter.

I believe you can just use ACCESS to open the wizard.mda and change the code
in there.  I think you'll have to rename it wizard.mdb and uncomment the
line in your msaccess.ini to not use the wizard.mdb in the [utility] section.

Hope it helps


----------------------------------------------------------------------
"Never be afraid of asking questions"

Tony <Always having fun> Tam                 [e-mail]
----------------------------------------------------------------------
=========================================================================
Date:         Thu, 11 Mar 1993 13:08:22 EST
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re:  Repeated main rows in form/subform

The following message was returned to me as an error.  Several lines of
header have been excised to make it palatable to the system.

REPOSTED MESSAGE BEGINS:

Message-Id: <[e-mail]>
Received: by hamilton
        (16.8/16.2) id AA11813; Thu, 11 Mar 93 11:43:46 -0500
Date: Thu, 11 Mar 93 11:43:46 -0500
From: Kawi Neal <[e-mail]>

> Message-Id: <[e-mail]>
> Received: from PUCC.PRINCETON.EDU by pucc.Princeton.EDU (IBM VM SMTP V2R2)
>    with BSMTP id 1886; Mon, 08 Mar 93 23:33:01 EST
> Received: from PUCC.BITNET (NJE origin LISTSERV@PUCC) by PUCC.PRINCETON.EDU
 (LMail V1.1d/1.7f) with BSMTP id 5512; Mon, 8 Mar 1993 23:33:01 -0500
> Date:         Tue, 9 Mar 1993 07:25:26 SAT
> From: "Trevor D. Rotzien" <[e-mail]>
> Subject:      Repeated main rows in form/subform
> Status: RO

> This query is used as the record source for a form/subform:


> FROM  Main List, Synonyms,


> I want all records in Main List to be displayed once, and any records
> matching the join criteria to be displayed in the subform. What I am
> getting is a matching record in Main List repeated for as many times
> as there are matching records in Synonyms. The matching records in
> Synonyms are displayed correctly in the subform.

> Comments?

> ----------------------------------------------------------------------
> trevor d. rotzien         marine science group
> k.f.u.p.m. box 118        water resources & environment division
> dhahran 31261             the research institute
> saudi arabia              king fahd university of petroleum & minerals

> email: [e-mail]
> office: -966-03-860-4316
> ----------------------------------------------------------------------


Note : Disregard previous mail.....accidentally sent off before completion..


Seems like you have a one-to-one relationship between the Main List and Synonyms
"Matching record in Main List repeated for as many times as there are
matching records in Synonyms."

What you could do is create two querries ( MainList & Synonyms )
Set the Properties of the MainList querry to Unique Values. Note : Your
form will now be base on unique MainList values

and base the Synonyms querry on the Control in the Main List form that contains
the join criteria (the unique matching value).
Note : You can use control ( [ContrlName]) values as the basis of you criteria.


Kawi Neal
[e-mail]
MARCAM

REPOSTED MESSAGE ENDS

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 11 Mar 1993 16:00:20 EST
Reply-To:     "Nathan Brindle" <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Joining with MS-ACCESS list

I have been in correspondence with Georg Chytil, who runs another Access
list in Europe, regarding merging our two lists.  Unfortunately, it isn't
as easy as it sounds, and the closest we can come to this is giving him
a "full feed" of ACCESS-L without a direct return connection to MS-ACCESS.
This would unfortunately mean that some people who want to subscribe to
both lists would receive some duplicate mail.

Georg and I believe that there is enough interest on both sides to support
this even though some people will get some duplication of mail.  I would
like to go ahead with this project, but if there is a great deal of
negative feedback from ACCESS-L subscribers, I will bow to the will of
the majority.

Please send comments to me directly, rather than responding to the list.
Sincerely,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 11 Mar 1993 16:44:55 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Brian M. Glasgow" <[e-mail]>
Subject:      Runtime licensing for Access

Can anyone give me information concerning a Run_time License for MS-
Access. (AKA Added Value reseller packaging)  I have developed a few
good applications that I would like to sell as stand-alone
applications but am reluctant to sell the whole Access Package
(particularly at the new Suggested Price)
=========================================================================
Date:         Thu, 11 Mar 1993 15:57:18 MDT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         "Brian Keeler (403) - 471-8623" <[e-mail]>
Subject:      Microsoft Access - IIf function

From the database I have created, fields eg. name address1 address2 city
province postalcode, I am creating a report. The problem is that address2
is NULL sometimes, thus when you view or print the report you get

output lines on Report

line1    Brian Keeler                     Brian Keeler
line2    8403-44 avenue               or  8403-44 avenue
line3                                     Apartment 201
line4    Edmonton Alberta T6K0Z6          Edmonton Alberta T6K0Z6

What I used so that if address2 was NULL it would move the next line up and
I would have another function statement to put in a blank line on line 4
when address2 is null, this is right out of the user's guide Page 485
and it does not work.

=IIf([address2]Is Null,"|[city]| |[province]| |[postalcode]|","[address2]")

Could someone please explain why or give me a solution to work around
this problem.
Have I found a bug?? because when you look in the user guide manual and
compare the online help for the same IIf function the syntax is different.
I have tried both... thanks in advance...

Brian Keeler    (403) - 471-8623
Application Services Coordinator
Information Services Division
domain: [e-mail]
=========================================================================
Date:         Fri, 12 Mar 1993 17:19:21 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Runtime licensing for Access
In-Reply-To:  <[e-mail]> from "Brian M.
              Glasgow" at Mar 11, 93 04:44:55 pm

>
> Can anyone give me information concerning a Run_time License for MS-
> Access. (AKA Added Value reseller packaging)  I have developed a few
>
        Along the simular lines: has anyone heard of a compiler for ACCESS?
        I heard that it is being developed, but I don't know if that's true.
=========================================================================
Date:         Fri, 12 Mar 1993 18:21:52 -0700
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         FELLOWS STEVEN B <[e-mail]>
Subject:      Re: Runtime licensing for Access

I called Microsoft lastweek and asked them about this.
They said that a runtime licenseing version is in the works.
It would probably be priced the same as Access, but would enable you
to give your compiled database to a user who does not have Access.

This was according to a saleswoman.

Steven B. Fellows
[e-mail]
=========================================================================
Date:         Fri, 12 Mar 1993 17:28:06 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Microsoft Access - IIf function
In-Reply-To:  <[e-mail]> from "Brian Keeler"
              at Mar 11, 93 03:57:18 pm

>
> line1    Brian Keeler                     Brian Keeler
> line2    8403-44 avenue               or  8403-44 avenue
> line3                                     Apartment 201
> line4    Edmonton Alberta T6K0Z6          Edmonton Alberta T6K0Z6
>
   ...
>
> =IIf([address2]Is Null,"|[city]| |[province]| |[postalcode]|","[address2]")
>
   I don't have a manual at my side right now, but isn't it IsNull([address1])
   not [address2]Is Null?
   Also I am not familiar with "|[field]| |[field]|..." sintax.  I've seen here
   people refer to it, but I havn't used it yet.  It seems strange though, that
   you need to put it in ""... ,spacially the "[address]" stuff.

   Hope this doesn't destruct you and maybe helps...

   ----------------------------------------------------------------------------
   Dmitry Serebrennikov       [e-mail]
=========================================================================
Date:         Mon, 15 Mar 1993 10:50:42 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Brian J Read Datab" <[e-mail]>
Subject:      Microsoft Access - IIf function

*** Reply to note of 15/03/93 09:07
      [e-mail]     SERC RAL CCD SDD R27.G22 0235-44-6492
---------------------------------------------------------------
,lf access

Is it necessary to put each line of the address in a separate field given that
ACCESS allows multiline field values?

---------------------------------------------------------------
=========================================================================
Date:         Mon, 15 Mar 1993 08:38:37 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Rickey Thomas Tom <[e-mail]>
Subject:      case sensitive

Does anyone know how case sensitivity can be enforced in ACCESS.
It appears that (for example) "Id" == "ID" == "iD". Although the user will
unlikely have two keywords that differ only by case sensitivity. This is
unacceptable. I don't want to convert them all to lower or to upper case.
The problem is clear when data is imported into ACCESS and the data
is exported to a C program.

rick
=========================================================================
Date:         Mon, 15 Mar 1993 09:50:25 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      European Access List

I've had a couple of requests for the address of the European Access
list.  It is:

[e-mail]

Remember, I will be linking the two lists this evening, so subscribers
to both lists will have to put up with some duplicate mail.

Nathan Brindle
Listowner

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 15 Mar 1993 09:22:30 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: European Access List
In-Reply-To:  <[e-mail]> from "Nathan
              Brindle" at Mar 15, 93 09:50:25 am

>
> I've had a couple of requests for the address of the European Access
> list.  It is:
>
> [e-mail]
>
> Remember, I will be linking the two lists this evening, so subscribers
> to both lists will have to put up with some duplicate mail.

        I am sorry, I am unclear on this:  do you mean that being a subscriber
        of this (American) list I will also get the posts from the Euro list,
        or is only when I am the Euro subscriber I will be getting posts from
        here and Euro?  I.e. is the link you are going to make bidirectional?


dmitry serebrennikov      [e-mail]
=========================================================================
Date:         Mon, 15 Mar 1993 10:55:21 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Source and Destination for controls?

I've tried to post this before, but had trouble doing so. If you've seen
this one before, then just ignore this one.

I'm trying to define a control that does 2 things. It updates a field in
the underlying table (this control resides on a form). Also, the control's
value is determined by summing the records in a related table.

>From what I can tell, Access gives me a property called "source" that it
uses to dispaly/update from an underlying table or query. The problem is that
I want separate source and destination properties. I want the source
to be a dsum() function. That way, the user will see the form control having
the correct value. Also, I want to have a destination property that allows
that value (from the source) to be stored in the field of the underlying table.

I have tried making the source of the control the dsum function. But, of
course it did not update underlying table.

If you want to know specifically what I'm doing, read on...

I have a PurchaseOrders form with a POItems subform attached to it. One of the
controls on the POItems subform is a Quantity field. The Quantity field refers
to the total quantity of the specific item that has been ordered. To make it
interesting, if the user clicks on Quantity (or tries to enter the field)
another form pops up with more information on this PO item. It shows each
individual Sales Order that has at least one of these items ordered (that
should be applied to this Purchase Order).

For example, I can have Quantity 10 of item XYZ on the PO. These 10 can be
composed of 2 Sales Orders of 5 each (or any combination). Anyway, I want the
Quantity field on the PurchaseOrder form to reflect the total Quantity of this
particular item (for each Sales Order that applies). In this case it is 10.

I have everything working fine except that I can't get the control on the
PurchaseOrders form to show the correct total. Using dsum() as the source for
this control seems to sum the values correctly, but the underlying table does
not get updated.

I have thought of having one of the update properties of the pop-up form update
the PurchaseOrders form whenever the user updates the data in the pop-up.
That's not so bad, but I think it is error prone and redundant because I would
need a similar procedure for each field (of each form) that might need this
kind of update. I think Access should have separate source and destination
for each control.

Is there some better way to do this or should we have separate source and
destination for controls?


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Mon, 15 Mar 1993 14:16:47 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: European Access List
In-Reply-To:  Message of Mon,
              15 Mar 1993 09:22:30 -0800 from <[e-mail] ELEY.EDU>

OK, In order to clarify:

The link between ACCESS-L and MS-ACCESS is in one direction only.
MS-ACCESS will be subscribed to ACCESS-L and will distribute ACCESS-L
traffic to its own subscribers.  MS-ACCESS traffic will not normally
come to ACCESS-L unless a user there either a) replies to an ACCESS-L
posting or b) cc's his MS-ACCESS posting to ACCESS-L.

Think of this as a join between ACCESS-L and MS-ACCESS where the result
is:
    If you are an ACCESS-L subscriber you receive ACCESS-L mail only.
    If you are an MS-ACCESS subscriber you receive BOTH.

Hope this helps.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 15 Mar 1993 14:21:41 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: European Access List
In-Reply-To:  Message of Mon,
              15 Mar 1993 09:22:30 -0800 from <[e-mail] ELEY.EDU>

It just occurred to me that MS-ACCESS could be viewed as a local mail
exploder that subscribes to ACCESS-L (and there are several of those
at present) and works much the same way.  Just as we don't receive
local mail from people behind the mail exploders, we just won't receive
original MS-ACCESS mail unless someone cc's or replies to us.

Sorry to take up bandwidth but I want to make sure everyone understands
this process.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 15 Mar 1993 15:24:27 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Brian M. Glasgow" <[e-mail]>
Subject:      Re: Runtime licensing for Access

> Date:          Fri, 12 Mar 1993 17:19:21 -0800
> Reply-to:
>                "Microsoft Access Database Discussion List"              <ACCES
 [e-mail]>
> From:          Dmitry Serebrennikov <[e-mail]>
> Subject:       Re: Runtime licensing for Access
> X-To:          [e-mail]
> To:            Multiple recipients of list ACCESS-L <ACCESS-L%INDYCMS.BitNet@p
 ucc.PRINCETON.EDU>

> >
> > Can anyone give me information concerning a Run_time License for MS-
> > Access. (AKA Added Value reseller packaging)  I have developed a few
> >
>         Along the simular lines: has anyone heard of a compiler for ACCESS?
>         I heard that it is being developed, but I don't know if that's true.

>In answer to my own question about Run-Time Licensing, I contacted
MicroSoft and was informed that an "Access Developers Kit" would be
released about May 1, 1993. No price given.
=========================================================================
Date:         Mon, 15 Mar 1993 15:41:10 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Brad Hartmann <[e-mail]>
Subject:      EUROPEAN ADDRESS

    I acccidently deleted the European address. Would somebody please
e- mail it to me personaly so we don't unnecessarily use the net for
something already sent.  Thanks in advance!
=============================================================================
Brad Hartmann                                 University Of Missouri
Network Manager                               College Of Veterinary Medicine
[e-mail]            Columbia Missouri
PHONE: [phone]                         FAX: (314) 882=2950
=============================================================================
=========================================================================
Date:         Mon, 15 Mar 1993 16:58:05 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: Runtime licensing for Access
In-Reply-To:  Message of Mon,
              15 Mar 1993 15:24:27 CST from <[e-mail].M ISSOURI.EDU>

I attended a Microsoft seminar on Access and Windows back in January and
at that time, the presentor responded to the question of an Access run-time
by saying "some time late in the spring or early in the summer" and that
it would LIST at around $495.  This elicited many groans from the audience.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 16 Mar 1993 13:34:06 MET
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Chytil Georg <[e-mail]>
Subject:      test : please ignore

Sorry folks :
Testing the "reply to access-l"-feature of [e-mail] .
Users subscribed to both lists should get this message twice --like me .

                                        Georg

<-------Trust not a man who's rich in flax, his morals may be sadly lax------->
Chytil Georg Ex-Systemdamager@Dep. of VLSI (vlsivie) TU Wien  1040 Wien Austria
[e-mail]                                     +43/222/3718445
#include <extra_disclaimer.h>         Don't panic!       Fax: [phone]
=========================================================================
Date:         Tue, 16 Mar 1993 13:01:57 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Arthur B. Smith" <[e-mail]>
Subject:      Distribution Kit (Runtime license)

Talking to Microsoft, I hear that the Distribution Kit for ACCESS
will be available May 1.  An announcement will be sent to all
registered users of ACCESS concerning it, but I was told it would be
a separate product which would allow you to turn applications
developed under ACCESS into stand-alone applications that could then
be distributed royaltee-free.

In the most recent catalog (received yesterday) from PC ZONE, they
already list the ACESS Distribution Kit for $314.

Now y'all know as much about it as I do.  Hope that helps!

        -art
------------------------------ 8^) -----------------------------------
Arthur B. Smith                         [e-mail]
Dept. of Vet. Med. & Surg.              [phone] (voice)
A-353 Clydesdale Hall                   [phone] (FAX)
University of Missouri                  [phone] (Home)
Columbia, MO  65211                     Usual disclaimers apply!
=========================================================================
Date:         Wed, 17 Mar 1993 10:51:01 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      subs to MS-ACCESS

Georg Chytil has asked me to relay to ACCESS-L subscribers the information
that subscription requests for MS-ACCESS should be sent to:

[e-mail]

If you send them to MS-ACCESS, they just get distributed to the list.

Thanks,
Nathan Brindle
Listowner

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 17 Mar 1993 16:53:00 +0100
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Macro condition probs

Dear collegues,

W've recently started working with Access, primarily as a replacement for
buggy dBFast. We developed a signature-administration in dBFast and I
succeeded in transferring all data, although the pictures had to be done
one-by-one via the clipboard.
I'm experimenting with Access, trying to recreate the old work-environment
we had, also trying to avoid programming in Access Basic, for I want to
know how much can be done without programming.

The problem I currently have is the following:
When in a certain Form, I want to be able to activate a Button wich has
a specific Macro attached. This Macro should test if the current record
is either the last (or the first) record.
I don't seem to be able to use the DFirst, EOF and First functions here,
so how can I do it then? (I tried them but failed)


Martin Ederveen,
Hogeschool Eindhoven,
The Netherlands

[e-mail]
=========================================================================
Date:         Wed, 17 Mar 1993 13:44:44 -0600
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Bob Hambuchen <[e-mail]>
Subject:      Access Advisor Magazine

Today I received a card advertising a new magazine for Access users.
It is called Access Advisor and sells for $29 per year (6 issues).
The phone number is 800-336-6060 in USA, 619-483-6400 outside USA and
619-483-9851 for FAX.

I have no connection with this company, nor do I recommend the magazine.
I merely pass this along to anyone who may be interested.

Cheers!

Bob Hambuchen
[e-mail]
=========================================================================
Date:         Wed, 17 Mar 1993 16:47:54 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: Source and Destination for controls?
In-Reply-To:  <[e-mail]> from "Jim Renaud" at
              Mar 15, 93 10:55:21 am

> I'm trying to define a control that does 2 things. It updates a field in
> the underlying table (this control resides on a form). Also, the control's
> value is determined by summing the records in a related table.
>
> >From what I can tell, Access gives me a property called "source" that it
> uses to dispaly/update from an underlying table or query. The problem is that
> I want separate source and destination properties. I want the source
> to be a dsum() function. That way, the user will see the form control having
> the correct value. Also, I want to have a destination property that allows
> that value (from the source) to be stored in the field of the underlying
 table.
        Make the control either unbound or calculated (dsum function or whatever
        in the source property), then try assigning a macro to the before
        update property -- that may let you intersept Access and not comeback
        to you with "Controll is calculated" in the message bar.
        Other then that you can try some combination of two controlls one on top
        of another and setting one to invisible, unless the focus is on the
        (calculated) control.  When you put focus onto the calculated control
        your macro should take over and swap the controls from under the user,
        so that you will actually change the real control.

        Hope this helps.


        Dmitry Serebrennikov     at    [e-mail]
=========================================================================
Date:         Thu, 18 Mar 1993 10:06:59 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      Is there a Microsoft SQL Server list? + other questions

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
Does anyone know of such a list please?

Are any of you using Access to access microsoft SQL Server, or any other
SQL server?

Is anyone writing any ODBC interfaces to databases such as SQL/DS on VM or
VSE?

Anne

Thankyou
===============================================================
=========================================================================
Date:         Thu, 18 Mar 1993 14:57:15 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      Is it necessary to write programs in Access?

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
Dear all

I have been reading the mail from this list with much interest as a relatively
new user to access. Thanks to one bit of mail we eventually found out how
to get labels out! However what I dont understand is why there seems to be
so much programming going on? Is there really so much going on or is it
that others have found the way to get the forms and report code out as code
after haveing used the point and click interface.

What I would really like to know is what do people feel are the limitations
of Access such that programming forms and reports is necessary?

Regards
Anne

Thankyou
===============================================================
=========================================================================
Date:         Thu, 18 Mar 1993 10:47:11 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Is it necessary to write programs in Access?

I have found that Access requires some amount of programming either through
macros or Access Basic to do realistic forms/reports.

One example I have is that I have an order form that uses a combo box to
select the customer. On the order form are some text controls that display
the customer address, phone, etc. The form is based on a query that has the
Order table and Customer table joined (and other tables, also).

When I open the form, the form correctly showed that the customer name (default
in the combo box) matched the information in the text controls about that
customer. The problem was that if I selected a different customer through
the combo box, the associated customer data on the form did not get updated
to match the newly selected customer. The other text controls still had the
previous customer information.

Minimally, you would have to have a macro (or module) that could do a requery
or refresh on the "before update" property of the customer combo box control.
I did not have good luck with either of these (did not seem to work right) so
I ended up having a routine (access basic) that updated each control on the
form by looking up the information in the Customers table.

I think Access should do this automatically for me without having to
write any macro. Since Access knows that both the Order table and Customer
table are related, if I change the customer (CustomerNumber) on the form, it
should automatically update the other related customer data that is on the
form. [The tables are related with CustomerNumber field]

Some people might consider this a nit because it is still alot easier than
what we used to do with either Dbase or Clipper. But, it could be alot better.

There are more of these that I (and others) have seen. Maybe Microsoft is
reading this...


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Thu, 18 Mar 1993 14:03:23 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: Is it necessary to write programs in Access?
In-Reply-To:  Message of Thu,
              18 Mar 1993 10:47:11 PST from <[e-mail] L.COM>

I'm going to take a wild stab here...but did you use a form and a subform
setup, where the main form would hold customer data and the subform would
hold order data based on a query?  I have a form/subform set up that works
rather well without any macros, which displays the name of a service project
and other project-related information from the PROJECTS table in the main
form, and the name, member number, date, and hours worked for each member
in the subform (which is based on a query to a SERVICE HOURS table which
has a record for each member on each project.  I don't feel like I'm
describing this well, but it works very nicely for me.  BTW, I pull the
member's name out of a third table, APO, and the relationships between
the three are like this:

Table APO                Table SERVICE HOURS             Table PROJECTS
  Member Number -----------> Member Number
  (Member Data)              Project Number  <----------  Project Number
                             (Date, Hours                 (Project Data)
                              Worked, etc.)

As you can see, SERVICE HOURS really contains the nitty gritty, and it's
updated via a query.  My form looks a lot like an invoice, with the main
form in form view and the subform in datasheet view.  I can page through
projects by using the record arrows on the main form, or skim through
members who worked individual projects by using the record arrows on the
subform.

I'll admit I had to mess about with this a little to make it work, but
the upshot was that I had to read the manual and didn't need any macros.
I tried at first to make it work on a single form and couldn't do it--
because I was having the same problem you describe.

Hope this helps,
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 18 Mar 1993 15:47:58 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jeff 603/881-0494 <[e-mail]>
Subject:      Re: Is it necessary to write programs in Access?

If I've replied to the incorrect account, my apologies.

Observation from my limited experience with Access is that the more you want to
do with it, the more likely you are to at least use/need macros and perhaps some
functions.

Jim Renaud, if I understand your description of the order form you've developed,
I believe that there's a simpler solution to the updates that you might want to
try using macros. I've been working on a similar application and here's what
I've come up with:

For the Customer Name, use a unbounded combo box based on a Query of the
Customer table (i.e., the properties for the combo box would have nothing for
the control source, the Control Name something like CName and the Row Source
would be the name of the customer file query).

The rest of the Customer attribute text boxes would still be based on the query
you already have developed. Within that query in the column where you've
selected the Customer Name, enter the following on the criteria line
=forms![Myform]![CName]

Then create a macro whose sole function is requery. Attach this macro, I'll call
it General.Name to the AfterUpdate of the Name combo box.


jeff
=========================================================================
Date:         Thu, 18 Mar 1993 21:09:25 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: Macro condition probs

In message  <[e-mail]> you write:
>
>
> The problem I currently have is the following:
> When in a certain Form, I want to be able to activate a Button wich has
> a specific Macro attached. This Macro should test if the current record
> is either the last (or the first) record.
> I don't seem to be able to use the DFirst, EOF and First functions here,
> so how can I do it then? (I tried them but failed)

Why not use the DFirst and DLast function, assuming you have a unique field
in the table on which the form is based (a primary key)?  Use a macro
condition thus: DFirst("unique_field","table_or_query_on_which_form_is_
based")=forms!form_name!unique_field will be true for the first record
in the table.
=========================================================================
Date:         Thu, 18 Mar 1993 15:40:06 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         randy legeai <[e-mail]>
Subject:      Mailing Label Problem on DMP

Having recently purchased Access, the first thing I did was to
import a simple dbase file and create a mailing label form with
the formwizard.  Since there's a Panasonic kxp1180 attached to
my computer, I selected it for output and picked the appropriate
Avery label (4145).  This is a simple single-column form-feed
label for my simple dot-matrix printer.  I formatted the text
as Courier-12cpi (standard).  Imagine my dismay to see a
page preview that showed only 11 labels on a page (there are
12 labels per 'page' on standard 3.5 x 15/16" label sheets).
In addition, the top of the first line of the first label is
missing!  To make matters worse, the Design view shows a label
that is exactly the correct size, with the text perfectly placed!
The margin settings in Setup looked OK.  I've spent quite a bit
of time trying other margin settings, page sizes, labels, and even
different printer drivers, all with the same/similar result.  What am I
missing here??  Surely Access can print simple 1-across labels
on a standard dot-matrix printer.  Has anyone had a similar
experience?  Any suggestions would be greatly appreciated.  I
would hate to have to write code just to print such simple labels!
--
Randall Legeai                             [e-mail]
Federal Agency Affairs / Ctr. Bioenv. Research      Phn: 504/865-5758
327 Gibson Hall, Tulane University                  Fax: [phone]
New Orleans, Louisiana 70118-5698
=========================================================================
Date:         Thu, 18 Mar 1993 21:21:05 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: Source and Destination for controls?

In message  <[e-mail]> you write:
>
> > I'm trying to define a control that does 2 things. It updates a field in
> > the underlying table (this control resides on a form). Also, the control's
> > value is determined by summing the records in a related table.
> >
> > >From what I can tell, Access gives me a property called "source" that it
> > uses to dispaly/update from an underlying table or query. The problem is
 that
> > I want separate source and destination properties. I want the source
> > to be a dsum() function. That way, the user will see the form control having
> > the correct value. Also, I want to have a destination property that allows
> > that value (from the source) to be stored in the field of the underlying
>  table.
>         Make the control either unbound or calculated (dsum function or
 whatever
>         in the source property), then try assigning a macro to the before
>         update property -- that may let you intersept Access and not comeback
>         to you with "Controll is calculated" in the message bar.
>         Other then that you can try some combination of two controlls one on
 top
>         of another and setting one to invisible, unless the focus is on the
>         (calculated) control.  When you put focus onto the calculated control
>         your macro should take over and swap the controls from under the user,
>         so that you will actually change the real control.
>
Perhaps I am missing something here, but surely this would work:
Set the OnInsert (or OnCurrent if you want the value updated every time you
look at the record) property to
=my_func()

Then define a module function thus:
Function my_func ()
   forms![Your_Form]![Your_field] = dSum(whatever)
End Function

Come to think of it, you could also use a macro, with a single line:
SetValue, forms![Your_form]![Your_field], dsum(whatever)
=========================================================================
Date:         Thu, 18 Mar 1993 15:58:46 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Joseph Wu <[e-mail]>
Subject:      object oriented database in C++

I would like to know more about Object oriented database in C++ and if you
have information about the books, or FTP sites which might help my study,
please drop me a mail!!!  Thanks
=========================================================================
Date:         Thu, 18 Mar 1993 14:45:46 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Is it necessary to write programs in Access?

>
> Jim Renaud, if I understand your description of the order form you've
 developed,
> I believe that there's a simpler solution to the updates that you might want
 to
> try using macros. I've been working on a similar application and here's what
> I've come up with:
>
> For the Customer Name, use a unbounded combo box based on a Query of the
> Customer table (i.e., the properties for the combo box would have nothing for
> the control source, the Control Name something like CName and the Row Source
> would be the name of the customer file query).
>
> The rest of the Customer attribute text boxes would still be based on the
 query
> you already have developed. Within that query in the column where you've
> selected the Customer Name, enter the following on the criteria line
> =forms![Myform]![CName]
>
> Then create a macro whose sole function is requery. Attach this macro, I'll
 call
> it General.Name to the AfterUpdate of the Name combo box.
>
>
> jeff
>

Hmmm....it seems like the criteria is the only thing I was missing the first
time I attempted to do this. I had everything else you suggested.

We'll see if that works. [The problem with me is that I'm used to programming
these types of apps using dbase, clipper, or c. So, when I get frustrated
with Access, I tend to fix it with code.]

Thanks for the suggestion,


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Thu, 18 Mar 1993 15:15:13 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Source and Destination for controls?

> Perhaps I am missing something here, but surely this would work:
> Set the OnInsert (or OnCurrent if you want the value updated every time you
> look at the record) property to
> =my_func()
>
> Then define a module function thus:
> Function my_func ()
>    forms![Your_Form]![Your_field] = dSum(whatever)
> End Function
>
> Come to think of it, you could also use a macro, with a single line:
> SetValue, forms![Your_form]![Your_field], dsum(whatever)
>

No, you are not missing anything. I'll have to try this all again, but I
received an error using your second option when I tried it before. But, I
did not do this using OnCurrent of that record, I used the AfterUpdate property
 of the pop up form. In other words I was updating (trying to, anyway) the
main form from the pop up form whenever a Quantity changed. Although I was
using the long form notation, there was an error using dsum in this manner.
I will try this again and post the results.

Thanks for your suggestions.


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Thu, 18 Mar 1993 16:15:22 -0800
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
Comments:     <Parser> E: RFC822 "local part" (username) containing a blank was
              encountered. These usernames are not presently supported.
From:         Undetermined origin c/o Postmaster <[e-mail]>
Subject:      Re: Is it necessary to write programs in Access?
In-Reply-To:  Your message of Thu,
              18 Mar 93 14:03:23 -0500. <[e-mail]>

Of the several applications I've built so far, I've not yet found one that did
not require at least some macro or module coding in order to define a
satisfactory interface.  A typical example is my phone/address database:

In this application I have two tables, one containing per person information
(first name, last name, work phone, birthday, etc.) and the other containing
address information (zip code, address, city, state, etc.).  This structure was
chosen to allow multiple "persons" to share a single "address" record, but
therein lies its problem.  These tables have a one-to-many relationship from
address to person, but the query and form that unites them for editing sorts on
person.

When I constructed the form based on a query that joins a person record with an
address record via an address-id field stored with the person, I was able to
view and edit the combined data for any existing record.  However, if I tried to
add a new record to the form, new records would be created in the Person and
Address tables, but the Person field that would provide the link to the new
Address record would be left #NULL#.  I spent days trying to find a way within
the form, and then a way using macros, that would allow me to automatically set
that field.  What I finally developed was the following ABF:

   Function linkNameAddr()
      Dim ds As Database, n As Table, a As Table
      Set ds = CurrentDB()
      set n = ds.OpenTable("Name")
      n.MoveLast
      If IsNull(n.ADR) Then
         Set a = ds.OpenTable("Address")
         a.MoveLast
         n.Edit
         n.ADR = a.ADR
         n.Update
      End If
   End Function
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
[e-mail]        5686 First Court, West Linn, OR 97068

The geographical center of Boston is in Roxbury.  Due north of the
center we find the South End.  This is not to be confused with South
Boston which lies directly east from the South End.  North of the South
End is East Boston and southwest of East Boston is the North End.
________________________________________________________________________________
=========================================================================
Date:         Thu, 18 Mar 1993 16:28:46 -0800
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Is it necessary to write programs in Access?
In-Reply-To:  Your message of Thu,
              18 Mar 93 14:03:23 -0500. <[e-mail]>

Of the several applications I've built so far, I've not yet found one that did
not require at least some macro or module coding in order to define a
satisfactory interface.  A typical example is my phone/address database:

In this application I have two tables, one containing per person information
(first name, last name, work phone, birthday, etc.) and the other containing
address information (zip code, address, city, state, etc.).  This structure was
chosen to allow multiple "persons" to share a single "address" record, but
therein lies its problem.  These tables have a one-to-many relationship from
address to person, but the query and form that unites them for editing sorts on
person.

When I constructed the form based on a query that joins a person record with an
address record via an address-id field stored with the person, I was able to
view and edit the combined data for any existing record.  However, if I tried to
add a new record to the form, new records would be created in the Person and
Address tables, but the Person field that would provide the link to the new
Address record would be left #NULL#.  I spent days trying to find a way within
the form, and then a way using macros, that would allow me to automatically set
that field.  What I finally developed was the following ABF:

   Function linkNameAddr()
      Dim ds As Database, n As Table, a As Table
      Set ds = CurrentDB()
      set n = ds.OpenTable("Name")
      n.MoveLast
      If IsNull(n.ADR) Then
         Set a = ds.OpenTable("Address")
         a.MoveLast
         n.Edit
         n.ADR = a.ADR
         n.Update
      End If
   End Function
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
[e-mail]        5686 First Court, West Linn, OR 97068

I wish there was a knob on the TV that would turn up the intelligence.
There's one marked brightness, but it don't work, does it?
--Gallagher
________________________________________________________________________________
________________________________________________________________________________
Robert Reed                     Home Animation Ltd.             503-656-8414
[e-mail]        5686 First Court, West Linn, OR 97068

Why do they call them apartments when they're all stuck together
--Gallagher
________________________________________________________________________________
=========================================================================
Date:         Thu, 18 Mar 1993 20:09:21 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      : Form/Subform with triple relationship
In-Reply-To:  <[e-mail]> from "Nathan
              Brindle" at Mar 18, 93 02:03:23 pm

>  I have a form/subform set up that works
> rather well without any macros, which displays the name of a service project
> and other project-related information from the PROJECTS table in the main
> form, and the name, member number, date, and hours worked for each member
> in the subform (which is based on a query to a SERVICE HOURS table which
> has a record for each member on each project.  I don't feel like I'm
> describing this well, but it works very nicely for me.  BTW, I pull the
> member's name out of a third table, APO, and the relationships between
> the three are like this:
>
> Table APO                Table SERVICE HOURS             Table PROJECTS
>   Member Number -----------> Member Number
>   (Member Data)              Project Number  <----------  Project Number
>                              (Date, Hours                 (Project Data)
>                               Worked, etc.)
>
    So your subform is based on a query from what I understand?
    I had a simular setup, but I am not too satisfied with the speed.
    Now, I don't know if you've seen this, but when I create a form
    with a subform on a related table, then the update in the subform
    is done by Access very fast indeed, much faster then if I wrote an SQL
    query (or QBE for that matter).  Some how Access keeps track of positions
    in the related tables, and that makes sence.  What does not work, is when
    I try to stik in the subform something like "Member Name" using your
    example (i.e. reference to another table also related but to the subform).
    I can put a subform in a subform, and that works well, but that requires
    the original subform to be in a single form view, and I'd like in in
    continious form view.

    My question to you all is do you know how Access is able to update the
    subform so fast and is there a way that I can get to the same mechanism by
    writing a program or a query?


    Thanks.

    Dmtiry Serebrennikov                 [e-mail]
------------------------------------------------------------------------
Damn, why won't elm see my .signature file, so I don't need to type this in
every time?!?!?!
=========================================================================
Date:         Fri, 19 Mar 1993 11:23:22 +0100
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Still the macro condition problem

About the condition problems within the macro. David Adams wrote me a reply,
wich I tested of course:

>>
>> The problem I currently have is the following:
>> When in a certain Form, I want to be able to activate a Button wich has
>> a specific Macro attached. This Macro should test if the current record
>> is either the last (or the first) record.
>> I don't seem to be able to use the DFirst, EOF and First functions here,
>> so how can I do it then? (I tried them but failed)
>
>Why not use the DFirst and DLast function, assuming you have a unique field
>in the table on which the form is based (a primary key)?  Use a macro
>condition thus: DFirst("unique_field","table_or_query_on_which_form_is_
>based")=forms!form_name!unique_field will be true for the first record
>in the table.
>
I already tried DFirst, but not with the primary key, but this was easily
done.
I got a query named Personq on wich the form Pgeg is based, the orginal
table is named Personnel. The macro has the name macro1 (original eh?).
The field Pnumber is the primary key of the table.

I used the following syntax:

DFirst("Pnumber","Personq")=Forms!Pgeg!Pnumber

I get an error: Can't parse expression!
Actually this is again and again the same error I seem to get when trying to
use DFirst in the macro condition.
A function like First is obviously parsed well:

First([Pnumber])=[Pnumber]

But then I get an error when using the macro in the form:
Function isn't available in expressions!

These same things happen exactly with all the other things I tried: either
I get a parse error OR later an unavailable error.  *sigh*

What am I doing wrong here?

Martin Ederveen


-------------------------------------------------------------------------------
|  ing. Martin W. Ederveen           |  "In the future there will be real     |
|  Hogeschool Eindhoven              |   thinking machines.                   |
|  Rachelsmolen 1                    |   Yes, but who's thoughts will they    |
|  5612 MA Eindhoven                 |   be thinking?"                        |
|  tel. [phone]             |                                        |
|  [e-mail]              |   Quotation from Dr.Who: The Curse     |
|  [e-mail]                    |   of Fenric                            |
-------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 19 Mar 1993 21:32:47 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      I had though that Access supported the concept of NULLs

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
Dear all
When I create a table I want to be able to speficy that a partcular column
does not allow NULLs, I do not want to leave this important aspect of database
design to a FORM, can I do it. It is an important aspect of ANSI/ISO SQL.
The more that I look at Access the less I feel that it embodies the spirit
of the standard and the more that it seems to embody just a cloak of the
standard.

Normally to say that siomething supports a standard then it must pass at
least the FIPS 127 test. I feel very sorry that after some 7 years of
existance of the SQL 86 document that we are in this state.

I was also dissapointed to find that I could not use SQL language to
create a table. This makes life very difficult when say one has over 70
columns in a table and the definition of the create statement already
exists in an ascii file, because one is just reprodcueing what one has
in another database system on another platform.
Anne

Thankyou
===============================================================
=========================================================================
Date:         Fri, 19 Mar 1993 21:24:39 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: Still the macro condition problem

In message  <[e-mail]> you write:
> I got a query named Personq on wich the form Pgeg is based, the orginal
> table is named Personnel. The macro has the name macro1 (original eh?).
> The field Pnumber is the primary key of the table.
>
> I used the following syntax:
>
> DFirst("Pnumber","Personq")=Forms!Pgeg!Pnumber
>
> I get an error: Can't parse expression!
Firstly:
Are you sure you entered *exactly* what you show above?  Missing one of
the quotes, using a name with a space with the [ and ] or misplacing an !
would all cause the problem, but it happily took the above line when I tried
it.
Secondly:
You should use the dfirst function on the domain of the table, not the
form.  (You want to check if a record is the first in the table.  Remember,
DFirst will return the first record as given by the order of the records
for the Primary Key.)

> A function like First is obviously parsed well:
>
> First([Pnumber])=[Pnumber]
>
> But then I get an error when using the macro in the form:
> Function isn't available in expressions!
The function 'First' is only valid in certain places, as described in the
help section,  a macro condition is not one of them!

Hope this helps.
--
David Adams
=========================================================================
Date:         Fri, 19 Mar 1993 07:44:00 -0800
Reply-To:     Tony Waddell <eabbs![e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Tony Waddell <eabbs![e-mail]>
Subject:      STILL THE MACRO CONDITION

Please remove my name from the mailing list.  I'm not currently working
with MS ACCESS and find the information I'm receiving to be a bit
overwhelming at the moment.

Thanks,
Tony Waddell
=========================================================================
Date:         Fri, 19 Mar 1993 15:48:06 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: I had though that Access supported the concept of NULLs
In-Reply-To:  <[e-mail]> from "Anne L Zorner
              R27.G5/" at Mar 19, 93 09:32:47 pm

>
> I was also dissapointed to find that I could not use SQL language to
> create a table. This makes life very difficult when say one has over 70
> columns in a table and the definition of the create statement already
> exists in an ascii file, because one is just reprodcueing what one has
> in another database system on another platform.

        Did you try to paste the SQL code into the View/SQL window in a
        Create Query?  Or any query, I think the presents of the correct
        SQL sintax in that window will make any query into an Create
        query.  Just a thought.

        Also, you could import the structure of your existing database (if
        you actually have one created) or maybe it would let you import it
        in some other form using different import options from the SQL
        definitions.

        I also came across of something you might like to know: in the View/
        options menu choose General and set "Show system objects" to Yes.
        You will see a dozen of new tables show up in your tables menu.
        Try openning them and see what they are.  Some of them it woun't let
        you to see, but others you can read, and I think they are some
        Access internals that actually store the queries and other info.
        I don't have much experience with SQL, but I think these tables will
        give you access to some of the things you are used to be using in the
        standard SQL environment (dates of table creation/updates, characteris
        tics of tables.)

        These system tables are just tables, and you can write Basic code that
        works with them and maybe even changes them.  Moreover, I think that
        most of the "development tools" that are provided with Access as part
        of it (color pallete, macro editor, and other ugly things) are just
        forms that work with these tables.

> Normally to say that siomething supports a standard then it must pass at
> least the FIPS 127 test. I feel very sorry that after some 7 years of
> existance of the SQL 86 document that we are in this state.

        Again not knowing the actual benefits of SQL standard I would still
        agree that Access is a idol of inconsistensy.  There are, perhaps,
        five different syntaxies to call Basic functions, depending on what
        you do and where, plus you can't call the Subs!

------------------------------------------------------------------------------
Please, no flames -- I am using it and liking it, but what's true is true...
------------------------------------------------------------------------------
=========================================================================
Date:         Sat, 20 Mar 1993 10:37:19 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: I had though that Access supported the concept of NULLs

In message  <[e-mail]> you write:
>
> SQL Support Section (SQS)         Mail [e-mail]
> ===============================================================
> Dear all
> When I create a table I want to be able to speficy that a partcular column
> does not allow NULLs, I do not want to leave this important aspect of database
> design to a FORM, can I do it. It is an important aspect of ANSI/ISO SQL.
> The more that I look at Access the less I feel that it embodies the spirit
> of the standard and the more that it seems to embody just a cloak of the
> standard.

I have not found a way.  The problem is that you can't specify record
level validation at the table design stage, and this is what you would need
to do for this type of thing.  Specifying Not IsNull([Field_name]) won't
work since it won't check the field if nothing is entered in it.  You can
perform record level validation on a form, but I know you don't want to
(why?).

>
> Normally to say that siomething supports a standard then it must pass at
> least the FIPS 127 test. I feel very sorry that after some 7 years of
> existance of the SQL 86 document that we are in this state.

Indeed it is a unfortunate situation.  However, while standards are important
so is development and conforming to existing standards often holds us back
in a lot of ways (take the IBM PC as an example).  Furthermore, it isn't as
though Access doesn't provide a mechanism for what you are trying to do,
it is just that it's different from what you are used to, albeit that
what you want is part of a 'standard'.  This reminds me of an interesting
article in a recent issue .EXE magazine which talks about the idioms of
programming languages.  The main thrust of the article is that we should
embrace what a language has to offer...   Having said all that, the ability
to define record level validation at the table definition stage would
be a plus and if Microsoft what to have the best product then they should
implement it.

>
> I was also dissapointed to find that I could not use SQL language to
> create a table. This makes life very difficult when say one has over 70
> columns in a table and the definition of the create statement already
> exists in an ascii file, because one is just reprodcueing what one has
> in another database system on another platform.

You could enter SQL insert table code in the View SQL window of a query,
if your existing ascii file is a complete SQL statement that Access will
understand.  However, you can't specify the exact field details, (such
as field length or number type), just whether it is character,number,
logical etc.  Also you will get one record in the table.

Secondly, it is possible to manipulate tables programmaticly from Access
Basic, since their details are stored in the system table, MSysObjects.
This would be a non trivial task - to make it flexible it would have
to pass the ascii input file and be able to cope with whatever it found
there.



David Adams, Data Strike Computers Ltd.
=========================================================================
Date:         Sun, 21 Mar 1993 08:03:03 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Sunday EVERYDAY <[e-mail]>
Subject:      Re: subs to MS-ACCESS
In-Reply-To:  <no.id> from "Nathan Brindle" at Mar 17, 93 10:51:01 am

since you didn't say anything about UNsubs being sent here... here's
mine..
unsubscribe me to this list.

-jon madison
=========================================================================
Date:         Sun, 21 Mar 1993 13:56:20 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: subs to MS-ACCESS
In-Reply-To:  Message of Sun,
              21 Mar 1993 08:03:03 -0500 from <sl313028@SILVER.U CS.INDIANA.EDU>

OK, then I'll say it.  :)

If you wish to unsubscribe, please send the command

UNSUB ACCESS-L

to [e-mail] or [e-mail].

Standard nettiquette requires that requests for list functions not be
sent to the list (which does nothing for you) but to the ListServer,
which will process your request.  If trouble develops in trying to
do something, you should send mail to the listowner (me) rather than
to the list.

Thank you.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Mar 1993 10:57:09 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Pekka Koskinen CIMO <[e-mail]>
Subject:      Tab order

Hello Access-users!

I have some forms with quite a few fields, which I try to fit into one
screen. So, there are several rows and columns of them.

My problem is that the tab order never goes corectly (=left to right,
top to bottom) without doing it manually ("custom order"). The "natural
order" doesn't seem to work.

Is there something I'm doing wrong or have I found a BUG?

Thanks in advance!

Pekka

:) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)

    _/_/_/_/   _/   _/_/  _/_/  _/_/_/_/  "Never try to teach a pig to sing.
   _/    _/   _/   _/ _/_/ _/  _/    _/     You will only lose your temper,
  _/         _/   _/      _/  _/    _/        and it frustrates the pig."
 _/    _/   _/   _/      _/  _/    _/
_/_/_/_/   _/   _/      _/  _/_/_/_/

Pekka Koskinen    tel [phone]    fax [phone]
CIMO, P.O. Box 343, 00531 Helsinki, FINLAND
=========================================================================
Date:         Mon, 22 Mar 1993 11:50:04 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      Nesting Queries

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
On p 508 of the Language Reference Manual it says

subqueries; instead, you can nest multiple queries

has anyone found any references to how one nests multiple queries in either
the manuals or online help?

I want to use correlated subqueries and want to see whether they can be done.


example

select a.x,a.y from table1 a
where a.y not in (select b.y from table 2
              where b.x=a.x)
(note this is just a simplified example of what I want to do)

Anne

Thankyou
===============================================================
=========================================================================
Date:         Mon, 22 Mar 1993 11:56:10 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      Variable length vs fixed length character strings

SQL Support Section (SQS)         Mail [e-mail]
===============================================================

I want to be able to define that some columns allow variable length
character strings and some must be fixed length. According to the standard
this means that I want to use VARCHAR rather than CHAR. According to Accesses
relationship to the standard it saysthat LONGTEXT is supported for VARCHAR
but I dont seem to have the chnace to select LONG anything let alone TEXT from
the allowed list of Datatypes in the Table Definition screen,
have I got something missing?

Anne

Thankyou
===============================================================
=========================================================================
Date:         Sun, 21 Mar 1993 23:04:00 IST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Chezy Gal <[e-mail]>
Subject:      Can not install Access

Hello,

I'm having problems installing access on my pc. The install program tells
me that I  have not enough memory or disk space which is not true...

I've got 8 MB ram and 30 MB free disk... What's happening...?

Thanks,

Chezy Gal
Tel-Aviv University
=========================================================================
Date:         Mon, 22 Mar 1993 14:19:48 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      re: create table and standards etc

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
>>
>> I was also dissapointed to find that I could not use SQL language to
>> create a table. This makes life very difficult when say one has over 70
>> columns in a table and the definition of the create statement already
>> exists in an ascii file, because one is just reprodcueing what one has
>> in another database system on another platform.
>
>        Did you try to paste the SQL code into the View/SQL window in a
>        Create Query?  Or any query, I think the presents of the correct
>        SQL sintax in that window will make any query into an Create
>        query.  Just a thought.
    Pasteing does not work into the View/SQL Window, the Edit Menu option
   is not active at that point. There is no such thing as a CREATE Window
    except for creating a table from a query dataset.
>
>        Also, you could import the structure of your existing database (if
>        you actually have one created) or maybe it would let you import it
>        in some other form using different import options from the SQL
>        definitions.

     There is no compatible format. SQL is the thing that should be used.

>
>        I also came across of something you might like to know: in the View/
>        options menu choose General and set "Show system objects" to Yes.
>        You will see a dozen of new tables show up in your tables menu.
>        Try openning them and see what they are.  Some of them it woun't let
>        you to see, but others you can read, and I think they are some
>        Access internals that actually store the queries and other info.
>        I don't have much experience with SQL, but I think these tables will
>        give you access to some of the things you are used to be using in the
>        standard SQL environment (dates of table creation/updates, characteris
>        tics of tables.)

    Thankyou for that, indeed the MSysObjects does seem to have a list
    of all the tables as well as other things. I am not at the moment
    (I think) too worried as to whether these exist but I would be
    a little wary of writing any code against them, normally these
    tables are merely for information or system use, updating them
    directly (except for statistics adjustment ) would not be
   an action that I would recommend for any DBMS.
>
>        These system tables are just tables, and you can write Basic code that
>        works with them and maybe even changes them.  Moreover, I think that
>        most of the "development tools" that are provided with Access as part
>        of it (color pallete, macro editor, and other ugly things) are just
>        forms that work with these tables.
>
>> Normally to say that siomething supports a standard then it must pass at
>> least the FIPS 127 test. I feel very sorry that after some 7 years of
>> existance of the SQL 86 document that we are in this state.
>
>        Again not knowing the actual benefits of SQL standard I would still
>        agree that Access is a idol of inconsistensy.  There are, perhaps,
>        five different syntaxies to call Basic functions, depending on what
>        you do and where, plus you can't call the Subs!
>
    Sadly (?) Basic is not standardised, but there does exist an SQL
    standard. One of its main benefits is that one can move a database
    from one platform to another and work out that the create table,
    select, update, delete statement will all work in the same way.
    If one used a standard language eg C then in the main that should all
    work as well. More importantly it allows people to use different
    products and still understand that what they are asking gives the
    same result. The more differences the more time it takes to learn
    about a new environment.

    Windows is an interesting example of a
    defacto standard. Its use by so many product suppliers has meant
    taht I find I can go to a new product and almost immediately find
    my way around it.

    Because MSAccess has deliberatly changed the meaning
    behind some of the relational terminologies (in order to comply with
    dbase) so it means that it is harder for relationally experienced
    users to use it.

Anne

Thankyou
===============================================================
=========================================================================
Date:         Mon, 22 Mar 1993 10:21:28 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: Can not install Access
In-Reply-To:  Message of Sun, 21 Mar 1993 23:04:00 IST from <A45@TAUNIVM>

Just a stab in the dark, but--are you running Windows in Standard or
386 Enhanced Mode?  If Standard, get into the Control Panel and change
it to 386 Enhanced.  That might clear up the memory problem, since the
two modes use memory differently.

No guarantee that this will work, but it might be worth a try.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Mar 1993 16:03:08 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      Import/Export Setup Window

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
Why is that this window does not allow me to switch back to other windows
in the access desktop? Since I can find no way of automatically getting
my 75 columns names into my specification (yes I need them cos I'm importing
from a fixed width file) I had hoped to use copy and paste on each column name
.

I can see that I should have started from the import spec to create the table
but that does not seem obvious, normally one creates the table first
and then loads in data (which may come from many sources.

Anne

Thankyou
===============================================================
=========================================================================
Date:         Mon, 22 Mar 1993 09:05:05 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Tab order
In-Reply-To:  <[e-mail]>; from "Pekka Koskinen CIMO"
              at Mar 22, 93 10:57 am

>
> I have some forms with quite a few fields, which I try to fit into one
> screen. So, there are several rows and columns of them.
>
> My problem is that the tab order never goes corectly (=left to right,
> top to bottom) without doing it manually ("custom order"). The "natural
> order" doesn't seem to work.
>

I have asked this question about a while ago, there was no answer for this.
I have found a "stupid " way of doing it. Try cut and paste in the order the
you want. e.g. if you want your field to go in 1,2,3,4,5,6 order, then start
cutting and pasting from field 1 , field 2 and .....so on.

Fred chin
=========================================================================
Date:         Mon, 22 Mar 1993 09:18:11 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Strange Tables?

>
> When creating some reports out of a query I suddenly had some strange
> tables in my list:
>
> They are all called MSysAces, MSysColumns, ...
>
> Seems as if they are internal Access-tables but why do I see them?
> Because I've opened the table as Administrator?
>
> Any hints welcome
>
> Martin
>
>

Try setting "Show system objects" to No in the "General" options (accessed
via View menu, Options).


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Mon, 22 Mar 1993 09:26:34 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Tab order

> >
> > I have some forms with quite a few fields, which I try to fit into one
> > screen. So, there are several rows and columns of them.
> >
> > My problem is that the tab order never goes corectly (=left to right,
> > top to bottom) without doing it manually ("custom order"). The "natural
> > order" doesn't seem to work.
> >
>
> I have asked this question about a while ago, there was no answer for this.
> I have found a "stupid " way of doing it. Try cut and paste in the order the
> you want. e.g. if you want your field to go in 1,2,3,4,5,6 order, then start
> cutting and pasting from field 1 , field 2 and .....so on.
>
> Fred chin
>

I don't have my PC in front of me, so I might be a little off here.
I think the item you are looking for in on the Edit menu, "Tab Order" option.

With the dialog that pops up, you can specify the exact order of fields.

Hope this helps


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Mon, 22 Mar 1993 09:34:51 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jerry Dunietz <[e-mail]>
Subject:      re: create table and standards etc

Anne L Zorner writes:

   Pasteing does not work into the View/SQL Window, the Edit Menu option
   is not active at that point. There is no such thing as a CREATE Window
    except for creating a table from a query dataset.

Note that although the main menu is not active when the View/SQL Window
is up, the standard keyboard accelerators for cut/copy/paste are
available in the View/SQL Window and other popup windows (like
property sheets) in Access. Ctrl-X is cut, Ctrl-C is copy, and Ctrl-V
is paste.

                                        Jerry J. Dunietz

Any opinions expressed are my own, and not necessarily those of my
employer.
=========================================================================
Date:         Mon, 22 Mar 1993 10:01:25 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: create table and standards etc
In-Reply-To:  <[e-mail]> from "Anne L Zorner
              R27.G5/" at Mar 22, 93 02:19:48 pm

> >        Did you try to paste the SQL code into the View/SQL window in a
> >        Create Query?  Or any query, I think the presents of the correct
> >        SQL sintax in that window will make any query into an Create
> >        query.  Just a thought.
>     Pasteing does not work into the View/SQL Window, the Edit Menu option
>    is not active at that point. There is no such thing as a CREATE Window
>     except for creating a table from a query dataset.
> >
> >        Also, you could import the structure of your existing database (if

    Try using the keyboard short cuts instead of the menu option, I think it
    worked for me (Ctrl+Ins), at least I am sure that you can actually type in
    that box!

    You right, though, if it supported the standard it would make life much
    easer for the developers who had a lot of experience with othe databases.

    Does MicroSoft SQL server support all the standards?  There is an interface
    to it included with MS-Access package, and you can also import the data
    from that server, so if the things are really bad you might try to import
    /create your tables using that back door :)

    Good Luck,
    Dmitry                                 [e-mail]
=========================================================================
Date:         Mon, 22 Mar 1993 10:24:34 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Counter field problem

> In a ACCESS table I have a date field as the primary key and a counter
> field to generate a record identifier.  I need the record numbers to be
> in the same sequence as the as the date even though the records are not
> entered in date sequence.  Any ideas?  As of now I have been unable to
> get ACCESS to re-identify the records when a new record is entered and
> its date places it in the middle of the table.  The new record is
> identified as the last record i.e. it has the highest id number.
>
> I need the identifier in sequence with the date so I can create a date
> range in a query.  In the query I use the date on the record as the
> beginning of the date range and the date on the next record to identify
> the ending date of the range.  The next record is identified by adding 1
> to the current records id number.
>

Because Access controls updates to Counter fields so stringently, I only
use Counter fields for tables that require an accessible number, but will
not be displayed publicly (like on forms and such). I know others may not
totally agree with me on that statement.

For example, an Order table might be considered a good place to use a Counter
field. This is because it makes it easier to increment the Order number (it's
done automatically). Also, it makes certain that no duplicate Order numbers
are ever used. The problem is that Access won't let you give a starting value
for Counter fields (at least I don't know how). Some customers that I am
developing this Access application for may not allow me to dictate what the
Order number (or invoice number, ...) is going to be. They may be currently
working a manual Order system and have already used thenumbers that the
Counter would start with.

I create a special table (call it Settings, SystemInfo, or whatever). This
table has only one record. Then define a field in this table for the current
OrderNumber, InvoiceNumber, etc. I have my own routine called NewOrderNumber()
that locks the table, gets the current OrderNumber, increments the OrderNumber
in the table, and finally unlocks the table.

That way, your application can easily be changed for different OrderNumber
starting values by setting that field to the correct number before the customer
uses your system for the first time. Of course, if your system is only used
in-house you might not want to go through the extra hassle I just described.

Now what does all this have to do with your problem??? If you wanted, you
could do the same procedure that I mentioned above. You could put the
"NewOrderNumber()" (or whatever name you need) function call in the default
value for the field that you are concerned about.

BTW, I also put in my "Settings" table information such as "Name", "Address",
and other pertinent information about the user of my database application. I
reference these fields in forms and reports, so that I only have to change
the values in the "Settings" table for other customers that want my application.


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Mon, 22 Mar 1993 11:30:48 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         RAM DIMBA <[e-mail]>
Subject:      Help on split transactions

This might not be right band-width to ask the following question,
since I am using Access, I thought I should try to get help from
professional Access users.

How do I split a transaction?  For example, a single payment to a
vendor may consist of cost of the product, applicable sales tax and
the shipping charges.  I would like to enter all these under one
data entry form (Checks).  I would appreciate any general ideas
 or any other suggestions.

I am a novice programmer,so please do not laugh!!!

Thanks in advance!


Ram Dimba
General Accounting
Stanford University
857 Serra Street MC 6205
Stanford, CA  94305
email : [e-mail]
=========================================================================
Date:         Mon, 22 Mar 1993 13:58:00 CST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      One-to-Many Relationship

I have a question to the Access experts:

How can I include a field in a form that is the ONE side
of a ONE-to-many relationship and be able to update the
undelaying table?

I understand how can I include a MANY-to-MANY subform.

Thanks,
Miguel A. Rivera
AT&T Bell Labs.
Naperville, IL. 60563
[e-mail]
=========================================================================
Date:         Mon, 22 Mar 1993 22:19:02 IST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Chezy Gal <[e-mail]>
Subject:      Re: Can not install Access
In-Reply-To:  Message of Mon, 22 Mar 1993 10:21:28 EST from <NBRINDLE@INDYCMS>

On Mon, 22 Mar 1993 10:21:28 EST Nathan Brindle said:
>Just a stab in the dark, but--are you running Windows in Standard or
>386 Enhanced Mode?  If Standard, get into the Control Panel and change
>it to 386 Enhanced.  That might clear up the memory problem, since the
>two modes use memory differently.
>
>No guarantee that this will work, but it might be worth a try.
>
>-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS

I'm running windows in enhanced mode, and using about 12MB more in
virtual mem. Still it won't load. Any more sagestions...? help..?


Thanks,

Chezy Gal
=========================================================================
Date:         Mon, 22 Mar 1993 15:55:37 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: Can not install Access
In-Reply-To:  Message of Mon, 22 Mar 1993 22:19:02 IST from <A45@TAUNIVM>

OK, How far do you get in the installation process and what are the error
messages that you get when Access will not install?  Maybe that would
provide a clue.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Mar 1993 15:55:06 -0600
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         MARK TURPIN <[e-mail]>
Subject:      RE: I had though that Access supported the concept of NULLs

  It is possible to paste SQL in to a query.

      1.  While in Notepad, copy the SQL code to the Clip Board.
      2.  In Access create a new query
      3.  Select SQL View and then press Ctrl V.
          This will copy the SQL to the query.
=========================================================================
Date:         Mon, 22 Mar 1993 22:16:32 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: Nesting Queries

In message  <[e-mail]> you write:
>
> SQL Support Section (SQS)         Mail [e-mail]
> ===============================================================
> On p 508 of the Language Reference Manual it says
>
> subqueries; instead, you can nest multiple queries
>
> has anyone found any references to how one nests multiple queries in either
> the manuals or online help?
>
> I want to use correlated subqueries and want to see whether they can be done.
>
>
> example
>
> select a.x,a.y from table1 a
> where a.y not in (select b.y from table 2
>               where b.x=a.x)

I believe there isn't a way to nest queries using the query builder, or
by entering SQL in the SQL box.  You can get the result you need in one
of two ways:
Using the query builder: create a query, save it and then create another,
'adding' the first as the table (in fact, it is a query) from which to
query.  Running the second query will cause the first to be executed, then
the second.  Note however, that the first must be an updateable query,
which means for one thing that it can't use parameters.
The more flexible way is to do it under Access Basic.  You can create a
query which runs on a dynaset, which itself was the result of a query,
that is use createdynaset, the first time using the database as the
object, the second time the dynaset created by the first.

If that was all good news (though I suspect it may not be), then here is
the bad news.  Access SQL does not support the In operator (the way you
have used it), and more troublesomely (is that a word?!), the Not In
construct.  So to acheive the exmaple code above you would have to scan
the dynaset, and test individual records.  There is no scan function in
Access, as there is in xBase, so you must use something like:
   set d_set = thedb.createdynaset("SQL")
   if d_set.recordcount<>0 then
      do while not d_set.eof
         ...
         ...
         d_set.movenext
      loop
   endif

If you aren't sure how to code the example you gave using this technique
just let me know and I am sure I can point you in the right direction.


David Adams, Data Strike Computers Ltd.
=========================================================================
Date:         Mon, 22 Mar 1993 22:19:54 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: re: create table and standards etc

In message  <[e-mail]> you write:
>
>     Because MSAccess has deliberatly changed the meaning
>     behind some of the relational terminologies (in order to comply with
>     dbase) so it means that it is harder for relationally experienced
>     users to use it.
But I would guess there are more people who have an xBase background
who are starting to use Access than people from other backgrounds, such
as those with a more rigorous SQL implementation (like DB2 or whatever).
Also, see my other reply regarding standards.
David Adams, Data Strike Computers Ltd.
=========================================================================
Date:         Mon, 22 Mar 1993 22:31:10 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: Import/Export Setup Window

In message  <[e-mail]> you write:
>
> SQL Support Section (SQS)         Mail [e-mail]
> ===============================================================
> Why is that this window does not allow me to switch back to other windows
> in the access desktop? Since I can find no way of automatically getting
> my 75 columns names into my specification (yes I need them cos I'm importing
> from a fixed width file) I had hoped to use copy and paste on each column name
> .
>
> I can see that I should have started from the import spec to create the table
> but that does not seem obvious, normally one creates the table first
> and then loads in data (which may come from many sources.
>
My we are at the keyboard a lot aren't we!  If you have so many complaints
about Access then why are you using it?!!! ;)

Seriously though, if you are to make progress with Access you must get
out of some old fashioned (and they maybe are just fashions, though I
doubt it) ways of thinking.  Access is a lot more object oriented than
other database systems, and so you should try not to go about things the
way you may have done in the past.  I found it frustrating at first since
I knew how to acheive what I wanted in xBase but couldn't see how it could
be done with Access.  Forgetting 50% of the things I knew about xBase, a
lot of things suddenly dawned on me, and I made much faster progress.

If Microsoft had taken the plunge you wouldn't define the tables at all,
you'd define the forms and that would build the tables.

To avoid using the import specification facility (since it was not flexible
enough for my needs) I wrote an import routine which used a table as a rule
base for where each field starts and ends, to which table it should be added
and what type of data it is.  It didn't reference any table or field
explicitly, instead implicitily from the rules table, so that I can add
new import types without changing the code, only the rules table... It
may sound long winded but it only took a couple of hours to put together.
David Adams, Data Strike Computers Ltd.
=========================================================================
Date:         Mon, 22 Mar 1993 22:31:58 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: Help on split transactions

In message  <[e-mail]> you write:
>
> This might not be right band-width to ask the following question,
> since I am using Access, I thought I should try to get help from
> professional Access users.
>
> How do I split a transaction?  For example, a single payment to a
> vendor may consist of cost of the product, applicable sales tax and
> the shipping charges.  I would like to enter all these under one
> data entry form (Checks).  I would appreciate any general ideas
>  or any other suggestions.
>
> I am a novice programmer,so please do not laugh!!!
>
> Thanks in advance!
>
>
> Ram Dimba
> General Accounting
> Stanford University
> 857 Serra Street MC 6205
> Stanford, CA  94305
> email : [e-mail]
>
Can you explain your requirements a bit more.  I can't see quite what you
are asking.
David Adams, Data Strike Computers Ltd.
=========================================================================
Date:         Mon, 22 Mar 1993 18:25:30 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Nathan Brindle" <[e-mail]>
Subject:      Re: Help on split transactions
In-Reply-To:  Message of Mon,
              22 Mar 1993 22:31:58 GMT from <[e-mail] N.CO.UK>

I think I see what he wants to do.  He wants to show a split transaction
on a check (or more likely, a deposit) in the check ledger.  Quicken does
this by opening a little window that allows you to put in multiple notes
and amounts, for instance, if you had 3 checks on a single deposit, the
ledger would show the TOTAL deposit and you could open the little window
for the DETAILS--how much each check in the deposit was, whom it was from,
etc.  This sounds like a job for a main form/subform where the subform
would be a datasheet view of the details.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 23 Mar 1993 09:24:36 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Pekka Koskinen CIMO <[e-mail]>
Subject:      Multiuser settings

I'm setting up an Access database, which up to 3-4 people might use
simultaneously (they are using the same form to add records to a same
table). Any recommendations on what are the best settings(refersh times
etc)?

Any hints appreciated!

Pekka

:) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)

    _/_/_/_/   _/   _/_/  _/_/  _/_/_/_/  "Never try to teach a pig to sing.
   _/    _/   _/   _/ _/_/ _/  _/    _/     You will only lose your temper,
  _/         _/   _/      _/  _/    _/        and it frustrates the pig."
 _/    _/   _/   _/      _/  _/    _/
_/_/_/_/   _/   _/      _/  _/_/_/_/

Pekka Koskinen    tel [phone]    fax [phone]
CIMO, P.O. Box 343, 00531 Helsinki, FINLAND
=========================================================================
Date:         Tue, 23 Mar 1993 01:04:49 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Mark Plutowksi <[e-mail]>
Subject:      Comparisons with Paradox & Foxpro

TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS:


Hopefully by now many of you have had a chance to evaluate ACCESS.
I am about to start an evaluation which will culiminate in a choice
between Access, Paradox, and Foxpro.  As I understand them
so far, each has different strengths, namely:

Foxpro: portability (Unix, Mac, PC, NT?)

Paradox: speed and programmability

Access: slick interface and ease of development


I intend to write a single mini application in each
of these and compare the results.  I want to do one
mini-application in depth, because it may be that,
while Access is great for doing certain things easily,
perhaps it is not much easier than Paradox, say, once
you require full flexibility.  Anyway, here's what
I'd like to evaluate:

A. Query, sort, filter, and copy time:
        1. 400,000 records with 2 fields and integer key.
        2. 10000 records with 128 fields, using a long character key
           which is a function of 2 or more fields.
        3. Finding the unique record in a set optimizing
           a set of constraints (say, 10000 records).

B. Rapid prototyping: time to implement a report or form
   using query, sort, or filter (i.e., A.1, A.2, and A.3.)

C. Programmability:  control each gives over formatting of
   complex forms, reports, and menu control flow.

D. Ease of use: look and feel of the resulting apps;
   importantly, is there a look and feel that is enforced
   by the package (important if the task is to be split
   up among programmers who are possibly separated by
   space or time.)

I'd be glad to report my results (don't hold your breath, though,
I'll be starting on this in a few weeks, needing to line
up the resources and programmers so that we can do all of
the comparisons concurrently.)

Are there any results, tips, or comments anyone can
provide that will make my results easier to obtain,
more meaningful, or more focussed?


Thanks,

= Mark Plutowski
=========================================================================
Date:         Tue, 23 Mar 1993 07:27:34 CST
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "R. D. McClary" <[e-mail]>
Subject:      Access unusable

     I have asked this in 2 different UseNET groups with no solution.  I
cannot run Access when using W4Wg's.  My machine will hang at any time - it
could by just after I click the icon, it could be just before I can select a
menu, it could be while I'm retrieving a file, etc.  The lockup is a total
hang.  I have no alternative but to power down and re-start (ouch!).

     My machine is an IBM 55/sx w/4Mb RAM and a 6 Mb perm. swapfile.  I run
only in 386Enh, and, using emm386.exe /noems, I have most of my drivers
loaded high.  System resources are generally in the low 80's.  The hang
happens whether or not I have other utilities going (clock, printman,
appbar, wallpaper or none, etc.), and it occurs whether or not I have
actually used the network.  It occurs even if I have neither accessed a
remote, shared device nor shared anything from my system.  Strangely enough,
other people in my workgroup can access and use the copy on my drive (yes,
we each have our own licnese!).

     Finally, I should say that I replaced the network driver with the one
that came with Access.  My files were all dated NOV 92.  When my colleagues
got their copies, their files were dated JAN 93.  I re-installed Access
using their copies - including an even newer net driver.  NO LUCK.  Right
now, I can only use Access by inserting a clean-boot floppy and re-booting.
Does anyone in this group have any ideasd?  Thanks.
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
               /|              []
            ` o.O '            []   [e-mail]
            =(___)=            []   R. D. McClary
               U               []   Department of Plant Pathology
          ACK!THPTPHH!         []   University of Illinois, Urbana-Champaign
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
=========================================================================
Date:         Tue, 23 Mar 1993 16:26:48 +0100
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Macro condition problem solved

Hey guys and girls!

I'm feeling enthousiastic because I solved (with some help) a problem.

The problem was the macro condition disn't accept my syntax:

DFirst("fieldname",tablename)=[fieldname]

Wich it should, according to everybody.

The solution came when we realized Access uses the Listseparator you have
assigned inside Windows under Configuration settings International.
So I had a semicolon (;) there defined as separator. That's why.

Another one solved. It seems one doesn't have to program much and most
things are possible from within the macro (at least that's what I keep trying).

Martin Ederveen.

-------------------------------------------------------------------------------
|  ing. Martin W. Ederveen           |  "In the future there will be real     |
|  Hogeschool Eindhoven              |   thinking machines.                   |
|  Rachelsmolen 1                    |   Yes, but who's thoughts will they    |
|  5612 MA Eindhoven                 |   be thinking?"                        |
|  tel. [phone]             |                                        |
|  [e-mail]              |   Quotation from Dr.Who: The Curse     |
|  [e-mail]                    |   of Fenric                            |
-------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 23 Mar 1993 12:22:00 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Ray Porrata" <[e-mail]>
Subject:      RE: Access unusable

Acces come with drivers especially for windows for workgroups.  This
must be loaded before using access on a workgroup setting.

As for windows:
Using the reference disk get all the address being used by memory
boards(eg: D800-DFFF for token ring cards.)  And in the [ENH386]
section of you system.ini file insert a line
emmexclude=MEMORYRANGE1-MEMORYRANGE2.

Ray :-)
----------
From: "R. D. McClary"  <netmail![e-mail]>
To: Multiple recipients of list ACCESS-L
<[e-mail]>
Subject: Access unusable
Date: Tuesday, March 23, 1993 7:27AM

     I have asked this in 2 different UseNET groups with no solution.  I
cannot run Access when using W4Wg's.  My machine will hang at any time - it
could by just after I click the icon, it could be just before I can select a
menu, it could be while I'm retrieving a file, etc.  The lockup is a total
hang.  I have no alternative but to power down and re-start (ouch!).

     My machine is an IBM 55/sx w/4Mb RAM and a 6 Mb perm. swapfile.  I run
only in 386Enh, and, using emm386.exe /noems, I have most of my drivers
loaded high.  System resources are generally in the low 80's.  The hang
happens whether or not I have other utilities going (clock, printman,
appbar, wallpaper or none, etc.), and it occurs whether or not I have
actually used the network.  It occurs even if I have neither accessed a
remote, shared device nor shared anything from my system.  Strangely enough,
other people in my workgroup can access and use the copy on my drive (yes,
we each have our own licnese!).

     Finally, I should say that I replaced the network driver with the one
that came with Access.  My files were all dated NOV 92.  When my colleagues
got their copies, their files were dated JAN 93.  I re-installed Access
using their copies - including an even newer net driver.  NO LUCK.  Right
now, I can only use Access by inserting a clean-boot floppy and re-booting.
Does anyone in this group have any ideasd?  Thanks.
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
               /|              []
            ` o.O '            []   [e-mail]
            =(___)=            []   R. D. McClary
               U               []   Department of Plant Pathology
          ACK!THPTPHH!         []   University of Illinois, Urbana-Champaign
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
=========================================================================
Date:         Tue, 23 Mar 1993 10:23:00 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "ext6774-Another one of those days..."
              <[e-mail]>
Subject:      Re: Help on split transactions

I'm not sure that I understand exactly what it is that you want to do
with these transactions.  Are you saying that you want to take the info
that you enter into the (checks) form and send it to different tables
or are you sending the information to different programs such as the
Peachtree accounting program? Both scenarios have solutions in Access.
Give us some more information and we will try to help you out.  And
remember, we all started at the begining at some point...
=========================================================================
Date:         Tue, 23 Mar 1993 16:26:35 -0400
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      simple question re counter

I am a complete novice with ACCESS or any other database package.
My question is:

If I use a data type of "counter" as the primary key in one table, can
it be a foreign key in another table.  And if this is possible, can
this foreign key be repeatable.

My problem is that I used counter as the primary key in my "customer"
table and as long as I had just one order in my "order" table with
the customer ID# (which was the "counter" data type) I was OK.  When
I tried to enter a new order from the same customer the system
refused.

Thanks for taking the time to help someone "wet behind the ears" and
designing a database for a school project.

[e-mail]
=========================================================================
Date:         Wed, 24 Mar 1993 13:09:07 GMT
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      thankyou for your replys to my notes

SQL Support Section (SQS)         Mail [e-mail]
===============================================================

I am sorry that I have not changed from my old fashioned view of the world
but I am trying! Thats why I am asking the questions. I keep hoping
that this new world might enable me to do things faster, without producing
applications for things that I would hope the system would do for me.
Being based on objects I had hoped that this world would allow me to take
an object and take pictures of it in different views, say having a table
and creating a default export filter to it with column names in place
and sample column numbers for within a fixed text file. Or that because
I was in one window that it would not stop me from being able to get
access to the main windows point and click options. I beleive in things
like orthogonality having to use fast paths strikes me to herralding from
the old world.

I am driven by my mouse, he is a friendly rodent and I get quite disspaointed
when he cant be exercised.

Again thanks for all the notes. I probably wont answer them all cos sadly
I am still based, in the main, in that old world of mainframe operating
office systems.

Re the standards issue... I am not the one claiming compatability.
Just one requesting it, and wondering whether anyone else cared at all.

Anne
Thankyou
===============================================================
=========================================================================
Date:         Wed, 24 Mar 1993 10:35:00 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Vince Scarafino <[e-mail]>
Subject:      Re: Comparisons with Paradox & Foxpro
In-Reply-To:  Message of 23 Mar 93 04:04 EST from "Mark Plutowksi"

 >Date:  23 March 1993 04:04 est
 >From:  Mark Plutowksi <pluto%cs.UCSD.EDU%SDSC.BITNET at PUCC.PRINCETON.EDU>
 >Subject:  Comparisons with Paradox & Foxpro

 >TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS:
 >
 >
 >Hopefully by now many of you have had a chance to evaluate ACCESS.
 >I am about to start an evaluation which will culiminate in a choice
 >between Access, Paradox, and Foxpro.  As I understand them
 >so far, each has different strengths, namely:
 >
 >Foxpro: portability (Unix, Mac, PC, NT?)
 >
 >Paradox: speed and programmability
 >
 >Access: slick interface and ease of development
 >
 >
 >I intend to write a single mini application in each
 >of these and compare the results.  I want to do one
 >mini-application in depth, because it may be that,
 >while Access is great for doing certain things easily,
 >perhaps it is not much easier than Paradox, say, once
 >you require full flexibility.  Anyway, here's what
 >I'd like to evaluate:
 >
 >A. Query, sort, filter, and copy time:
 >        1. 400,000 records with 2 fields and integer key.
 >        2. 10000 records with 128 fields, using a long character key
 >           which is a function of 2 or more fields.
 >        3. Finding the unique record in a set optimizing
 >           a set of constraints (say, 10000 records).
 >
 >B. Rapid prototyping: time to implement a report or form
 >   using query, sort, or filter (i.e., A.1, A.2, and A.3.)
 >
 >C. Programmability:  control each gives over formatting of
 >   complex forms, reports, and menu control flow.
 >
 >D. Ease of use: look and feel of the resulting apps;
 >   importantly, is there a look and feel that is enforced
 >   by the package (important if the task is to be split
 >   up among programmers who are possibly separated by
 >   space or time.)
 >
 >I'd be glad to report my results (don't hold your breath, though,
 >I'll be starting on this in a few weeks, needing to line
 >up the resources and programmers so that we can do all of
 >the comparisons concurrently.)
 >
 >Are there any results, tips, or comments anyone can
 >provide that will make my results easier to obtain,
 >more meaningful, or more focussed?
 >
 >
 >Thanks,
 >
 >= Mark Plutowski

I don't know if my request is within the scope of what you are trying to
do.  If it isn't please feel free to ignore it.  However, one item of
interest is the extent to which applications can be incorporated into a
truely distributed environment.  The ease of these packages working with
other relational data base environments, such as Sybase, Ingress,
ORACLE, DB2 would help some of us understand the implication of choosing
these packages vis-a-vis SQL language interoperability.  This might be a
lot more work than you bargained for, but you asked!  :-)

Vince
=========================================================================
Date:         Tue, 23 Mar 1993 16:06:24 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Toby Rockwell <[e-mail]>
Subject:      Access on a Network

Maybe I'm missing some important point, but I have not been able to get
the answer from the documentation, or from MS support, or from local
computer staff.

What I want to do is run an ACCESS application as an order entry system
for a small company.  This will run on 4 PC's each running
a (registered) copy of access; but all using a single database so that
the customer, order, order-entry-line, (etc.) tables are commonly
accessed, updated and used for output.  From what I have been able
to find out, there would be no problem doing this on a traditional
Client/Server net.  But this seems like killing a gnat
with an elephant gun since it seems that a peer to peer
network would more than suffice.  HOWEVER, I have received
conflicting information as to whether or not such a network (WFWG,
LANtastic, or NetWare Lite) can accomplish this.  I would love to throw
a few more dollars Bill Gates way and solve this with WFWG; but first I
would like to know if that would work.  Can anyone tell me if it will.

Alternatively, what IS the solution.  We are not of a size to hire a
network guru; and the size of the network and application is teeny by
most networking standards.
=========================================================================
Date:         Wed, 24 Mar 1993 08:19:14 CST
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "R. D. McClary" <[e-mail]>
Subject:      Success with Access and W4WG's

     My thanks to those that replied to my inability to use Access while
W4WG's was running.  I needed to exclude the section of memory used by my
network card.  I think it works now.
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
               /|              []
            ` o.O '            []   [e-mail]
            =(___)=            []   R. D. McClary
               U               []   Department of Plant Pathology
          ACK!THPTPHH!         []   University of Illinois, Urbana-Champaign
[][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
=========================================================================
Date:         Wed, 24 Mar 1993 11:38:20 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jim Renaud <[e-mail]>
Subject:      Re: Access on a Network

>
> Maybe I'm missing some important point, but I have not been able to get
> the answer from the documentation, or from MS support, or from local
> computer staff.
>
> What I want to do is run an ACCESS application as an order entry system
> for a small company.  This will run on 4 PC's each running
> a (registered) copy of access; but all using a single database so that
> the customer, order, order-entry-line, (etc.) tables are commonly
> accessed, updated and used for output.  From what I have been able
> to find out, there would be no problem doing this on a traditional
> Client/Server net.  But this seems like killing a gnat
> with an elephant gun since it seems that a peer to peer
> network would more than suffice.  HOWEVER, I have received
> conflicting information as to whether or not such a network (WFWG,
> LANtastic, or NetWare Lite) can accomplish this.  I would love to throw
> a few more dollars Bill Gates way and solve this with WFWG; but first I
> would like to know if that would work.  Can anyone tell me if it will.
>
> Alternatively, what IS the solution.  We are not of a size to hire a
> network guru; and the size of the network and application is teeny by
> most networking standards.
>

This is exactly what I'm working on right now. When finished, 5 users will be
able to enter orders, write POs, print invoices (my client has multiple types
of invoices they need), receive shipments (ordered from POs), and finally
ship the end product out (from the sales orders).

Right now, I have the sales order (add and search) working. PO system is about
75% done. Invoicing is about 30% done. The rest is still "blue-sky" right
now. There is a lot of underlying forms and tables that work too; like
Customers, Vendors, Parts, Manufacturers, Employees, etc.
Right now I have two computers in a WFWGs network that can create orders and
update any other the other stuff I mentioned is complete.

So the answer to your question is definitely YES. WFWGs can handle doing what
you want. I do it (albeit partially) now. I expect to have most of it finished
in a couple of weeks. I have NOT had ANY problems using Access on WFWGs. Just
make sure you install the network disk (that comes with Access) before using
your system on the WFWG network.

Also, my client is very pleased with what I have done with Access so far.
The Schedule+, eMail, and Chat systems that come with WFWGs have really excited
my client also.

Go for It!


-----------------------------------------------------------------------

Jim Renaud                              [Standard Disclaimer]

Amdahl Corporation
M/S 205                                 Phone:  [phone]
Bldg. M3  Room 235                      Fax:    [phone]
1230 E. Arques Avenue                   Email:  [e-mail]
Sunnyvale, CA 94088-3470
=========================================================================
Date:         Tue, 23 Mar 1993 21:54:13 GMT
Reply-To:     [e-mail]
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: Comparisons with Paradox & Foxpro

In message  <[e-mail]> you write:
>
> TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS:
>
>
> Hopefully by now many of you have had a chance to evaluate ACCESS.
> I am about to start an evaluation which will culiminate in a choice
> between Access, Paradox, and Foxpro.  As I understand them
> so far, each has different strengths, namely:
>
> Foxpro: portability (Unix, Mac, PC, NT?)
>
> Paradox: speed and programmability
>
> Access: slick interface and ease of development
>
With respect, in *my* opinion this is complete bunk.  Taking each point you
mention in turn... Versions of Fox for Unix and the Mac are way behind the
DOS versions at present, though it may be a factor in the future.  And what
about ODBC allowing cross platform data sharing? Always
remember that Microsoft are using FoxPro to get at the substantial xBase
database market.  In the future, when xBase's popularity falters (as surely
it will, have you looked at a Fox for Win application's code for example)
then what happens to FoxPro and the development of versions on other
platforms?  All of the OS's you mention (if you are talking about a PC
running Windows) have GUI and are becoming more and more object oriented -
xBase is just about the least object oriented thing you could have.  Surely
it makes sense to use a tool that was designed correctly from that start?
Speed and programmability of Paradox may be a more reasonable statement.
However, I have yet to seem it out perform FoxPro.  It is faster than
Access when it comes to queries, but opening a form on the screen takes
an hour and a day (on a fast PC).  Programmability is most certainly a
strong point of Paradox, but again, I have not seen anything *useful* that
cannot be done with other packages.  Access does have a slick interface but
then so does Paradox, and even Fox for Windows screens can look very slick,
as long as they weren't written for Fox for DOS.  Development is easier in
that more is taken care of by the system than in Fox, but not more than in
Paradox.  Which do I think is best?  It depends.  See below.

>
> I intend to write a single mini application in each
> of these and compare the results.  I want to do one
> mini-application in depth, because it may be that,
> while Access is great for doing certain things easily,
> perhaps it is not much easier than Paradox, say, once
> you require full flexibility.  Anyway, here's what
This is a good way of evaluating the applications.  It could be a lengthy
process though - don't make the applications too simple else you won't
have the full picture.

> I'd like to evaluate:
>
> A. Query, sort, filter, and copy time:
>         1. 400,000 records with 2 fields and integer key.
>         2. 10000 records with 128 fields, using a long character key
>            which is a function of 2 or more fields.
>         3. Finding the unique record in a set optimizing
>            a set of constraints (say, 10000 records).
This are definite requirements and should be easy enough to test - though
see notes below regarding Access's performance.
>
> B. Rapid prototyping: time to implement a report or form
>    using query, sort, or filter (i.e., A.1, A.2, and A.3.)
Significantly faster in Paradox and Access than Fox I would guess, unless
you have a lot of xBase expertise (maybe) again see below.
>
> C. Programmability:  control each gives over formatting of
>    complex forms, reports, and menu control flow.
Access is generally considered to be the least flexible of the three and
yet I have just completed an application using it which required a very
complex flow between forms, things happening automatically etc.  It coped
fine.
>
> D. Ease of use: look and feel of the resulting apps;
>    importantly, is there a look and feel that is enforced
>    by the package (important if the task is to be split
>    up among programmers who are possibly separated by
>    space or time.)
All three tools can build easy to use applications - it is more in the skill
of the developer than the package.  Paradox would probably provide the most
flexibility but do you need it?
>
> I'd be glad to report my results (don't hold your breath, though,
> I'll be starting on this in a few weeks, needing to line
> up the resources and programmers so that we can do all of
> the comparisons concurrently.)
I'd be interested to read them.

The choice between Fox and Access.
I think that the only reasons in the short term not to choose Access are
(a) existing xBase applications (not data) and/or expertise and
(b) performance.  In the medium and long term I think the performance issue
will go away - Access is bound to offer at least the performance of Fox.
Think about it - Microsoft has access (no pun intended) to the technology
which gives Fox its speed.  The only reason these software methods couldn't
be employed and benefited from in Access is if the internal data structures
of Access were not up to scratch.  Would Microsoft really design a database
product with data structures poorer than those designed years back (for
dBase)?  I don't think so.  And if Microsoft were really going to propogate
the Fox product and evolve it then how come it lacks features such as ODBC?
Thus all you are left with is the not insignificant factor of xBase
expertise and applications.  Still, are you still riding a horse because
driving a car is more complicated?
Between these two and Paradox is tougher.  Try your mini-applications and
see what you think.  It may come down to a choice between Borland and
Microsoft, rather than the products, and where you think they are each
taking them in future.

I hope this helps.  I would be interested to hear what you think of what
I have said.

David Adams

David Adams, Data Strike Computers Ltd.
=========================================================================
Date:         Wed, 24 Mar 1993 16:26:34 PST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         "Ray Porrata" <[e-mail]>
Subject:      RE: Access on a Network

This should work without a hitch.

The first item is to implement a pc which will act as a server.  Using
WFWG, this computers resources will have to be shared very well(it may
need more memory, HD space, etc.) also in the control panel make sure
the resources shared fastest settings are set.

Distributing the DB
The database should be kept on the server & everyone else pounding it.
It shouldn't be too hard to get the rest together.

Ray :-)
----------
From: Toby Rockwell  <netmail![e-mail]>
To: Multiple recipients of list ACCESS-L
<[e-mail]>
Subject: Access on a Network
Date: Tuesday, March 23, 1993 4:06PM

Maybe I'm missing some important point, but I have not been able to get
the answer from the documentation, or from MS support, or from local
computer staff.

What I want to do is run an ACCESS application as an order entry system
for a small company.  This will run on 4 PC's each running
a (registered) copy of access; but all using a single database so that
the customer, order, order-entry-line, (etc.) tables are commonly
accessed, updated and used for output.  From what I have been able
to find out, there would be no problem doing this on a traditional
Client/Server net.  But this seems like killing a gnat
with an elephant gun since it seems that a peer to peer
network would more than suffice.  HOWEVER, I have received
conflicting information as to whether or not such a network (WFWG,
LANtastic, or NetWare Lite) can accomplish this.  I would love to throw
a few more dollars Bill Gates way and solve this with WFWG; but first I
would like to know if that would work.  Can anyone tell me if it will.

Alternatively, what IS the solution.  We are not of a size to hire a
network guru; and the size of the network and application is teeny by
most networking standards.
=========================================================================
Date:         Wed, 24 Mar 1993 19:42:25 -0800
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Mark Plutowksi <[e-mail]>
Subject:      Re: Comparisons with Paradox & Foxpro

In response to my post:

> TO THOSE OF YOU WHO HAVE USED PARADOX AND FOXPRO FOR WINDOWS:
>
>
> Hopefully by now many of you have had a chance to evaluate ACCESS.
> I am about to start an evaluation which will culiminate in a choice
> between Access, Paradox, and Foxpro.  As I understand them
> so far, each has different strengths, namely:
>
> Foxpro: portability (Unix, Mac, PC, NT?)
>
> Paradox: speed and programmability
>
> Access: slick interface and ease of development
>

David Adams replies:

:  With respect, in *my* opinion this is complete bunk.

Ok, so I stand corrected!  Actually, thanks.  Scratch FoxPro,
after hearing what you've had to say about its ease of development.
My business partner was selling me on its speed and portability,
but I want to get something out to market THIS year, and don't
need xBase compatibility, nor do I really need portability
and totally blinding speed this year.  By the time I do, something
better will probably be here.  You brought up another key issue,
too, that I forgot about: CONNECTIVITY.  Access has it now.
I'm not sure how Paradox compares in this respect, so would
appreciate comments from PDox users on this.


: Access does have a slick interface but then so does Paradox, [...]
: Development is easier in that more is taken care of by the system
: than in Fox, but not more than in Paradox.


If I can build what I want quickly and still
have something my customer finds easy to use, that is reasonably
responsive (i.e., not SLOW) then why go with Access over Paradox?

I'm surprised to hear that PDox takes so long to open a form, though.



: In the medium and long term I think the performance issue
: will go away - Access is bound to offer at least the performance of Fox.

: I hope this helps.  I would be interested to hear what you think of what
: I have said.

: David Adams, Data Strike Computers Ltd.

It has helped a lot, thanks.  I'll focus on the comparison between
PDox and Access, and am interested to test the response w.r.t. forms.

I've liked what Borland has done with the compiler gui,
and expect them to come on strong with databases mgt systems.


= Mark
=========================================================================
Date:         Thu, 25 Mar 1993 09:04:56 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Jefrem Iwaniw <[e-mail]>
Subject:      Access vs. FoxPro for Win

Since my copy of Paradox for Windows is still in shrink-wrap on my
shelf, I'll have to refrain from commenting on it for now :=).

Mark Plutowksi <[e-mail]> writes:
> Ok, so I stand corrected!  Actually, thanks.  Scratch FoxPro,
> after hearing what you've had to say about its ease of development.

In many ways, Access *is* much easier to develop on, simply because
you can do so much without any programming at all (as has been
mentioned many times in this mailing list).  For small- to medium-
sized applications, Access is clearly the platform of choice.  However,
once your apps become large and/or specialized enough to require
significant amounts of programming, IMHO FoxPro Win becomes the
superior platform.

The ease of use of their menu-designer and screen designer can
be questioned (especially when compared to the tools available for
C++, Pascal, and VB), but they work and they work well, and the code
they generate is clear and concise.  Rather than creating a "form-based"
app in Windows, you create a "window-based" app, which by its very
nature responds much more quickly than a form since it is using
the native OS method of displaying information.

Debugging under FoxPro is much easier -- those Access message-boxes
that keep appearing one-after-the-other during initial runs can be
very frustrating.  Of course, we all write bug-free code, but in a
large app, we may need to eliminate certain "features" that have
mysteriously crept-in.

Additionally, seasoned Windows users don't need to learn anything
new to use a FoxPro Win app, whereas the default Access behavior is
a little odd (of course, this can be altered through careful attention
to ease-of-use, CUA-compliance, and the like).

Mostly, I just want to encourage those of you considering both
platforms to not write-off FoxPro, because in many situations, it is
the better choice.  BTW, my background is heavily C++, C, Windows, and
X/Motif, while my database experience (Clipper, FoxPro, Access, SQL)
is relatively recent (last year or so), so I may be biased.  Just my
HO.

-Jefrem Iwaniw
Pelican Software Corporation
=========================================================================
Date:         Thu, 25 Mar 1993 09:18:03 EST
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         Harry E Noel <[e-mail]>
Subject:      request for listserv manager

I know this is bad form but I have tried to get the listserv to dropp
me via mail and it claims not to recognize me.  Strange since I
originally sent the request in by mail the first time.

Anyway, please remove me from the list.

Sorry, but I tried... :-)

thanks
=========================================================================
Date:         Thu, 25 Mar 1993 12:01:38 -0500
Reply-To:     "Microsoft Access Database Discussion List"
              <[e-mail]>
Sender:       "Microsoft Access Database Discussion List"
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Comparisons with Paradox & Foxpro

>Ok, so I stand corrected!  Actually, thanks.  Scratch FoxPro,
>after hearing what you've had to say about its ease of development.
>My business partner was selling me on its speed and portability,
>but I want to get something out to market THIS year, and don't
>need xBase compatibility, nor do I really need portability
>and totally blinding speed this year.  By the time I do, something
>better will probably be here.  You brought up another key issue,
>too, that I forgot about: CONNECTIVITY.  Access has it now.
>I'm not sure how Paradox compares in this respect, so would
>appreciate comments from PDox users on this.

Access doesn't have the promised CONNECTIVITY yet.  Microsoft
has promised the functional OBDC connectivity for Access by
this summer.  I don't consider the SQL Server connectivity
available with the current Access is valuable.  If Microsoft
allows Access to connect to major databases like DB2, Sybase,
and Oracle, then Access is a real contender.

Borland has promised the same thing with its IDAPI (Independent
Database API).  Borland's IDAPI is supported by IBM, Lotus, Novell?.
Borland has stated that IDAPI will also cover Microsoft's ODBC.
Borland plans to release IDAPI by the summer.

It will be interesting to see how these things delivered and
implemented.

>If I can build what I want quickly and still
>have something my customer finds easy to use, that is reasonably
>responsive (i.e., not SLOW) then why go with Access over Paradox?
>
>I'm surprised to hear that PDox takes so long to open a form, though.

It is not quite true that Paradox for Windows (P4W) takes so long to
open a form.  Borland recommends a system with 386DX-33Mhz and 6MB RAM.
At home I installed P4W on my Swan 386DX-33 with 4MB RAM.
P4W takes about 10 seconds to come up.  Then it takes another 15 seconds
to open the first form. After that it works fine because all the needed
codes have been loaded in memory.

However I would not recommend that you do your development in P4W
using my configuration.  But the delivered applications can
probably run fine on user systems that are similar to mine.

About development, I would assume that you can develop better
applications with P4W.  P4W has a "container" design that is quite
interesting.  If you understand its use thoroughly you can build
efficient applications, because lots of codes are reusable (control
objects in a container will inherit codes and variables of its
container. A container can be a control object in another container.)
If codes and data can be reused and shared, your application's
response time should be better.

I am trying to develop an expert system using this containership
approach and custom methods.  I would not try this with Access because
Access depends too much on its macro language.  I find it is tedious
to work with both macro language and Access Basic.  With P4W, you
only have one language to learn.


>It has helped a lot, thanks.  I'll focus on the comparison between
>PDox and Access, and am interested to test the response w.r.t. forms.
>I've liked what Borland has done with the compiler gui,
>and expect them to come on strong with databases mgt systems.

The GUI interface of P4W is very good.  Its database engine is great.
Currently P4W doesn't support SQL.  SQL support will be provided via
IDAPI in this summer.  Based on the current database access features
of P4W, I would not be concerned about Borland's ability in providing
SQL support.  I think Borland takes more time to think about the
distributed database support.

Kha Tran

P.S.
FYI,

Borland has a new deal: you can get both Paradox for Windows
and Quatro Pro for Windows for $200.  How can they make a living
with that deal???

Also, PC Week magazine reports that Paradox for Windows has
outsold Access.  I hope Borland can quickly enhance P4W to
maintain its lead.
=========================================================================
Date:         Thu, 25 Mar 1993 17:02:02 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Brian M. Glasgow" <[e-mail]>
Subject:      Re: simple question re counter

> Date:          Tue, 23 Mar 1993 16:26:35 -0400
> Reply-to:
>                "Microsoft Access Database Discussion List"              <ACCES
 [e-mail]>
> From:          [e-mail]
> Subject:       simple question re counter
> To:            Multiple recipients of list ACCESS-L <ACCESS-L%INDYCMS.BitNet@p
 ucc.PRINCETON.EDU>

> I am a complete novice with ACCESS or any other database package.
> My question is:
>
> If I use a data type of "counter" as the primary key in one table, can
> it be a foreign key in another table.  And if this is possible, can
> this foreign key be repeatable.
>
> My problem is that I used counter as the primary key in my "customer"
> table and as long as I had just one order in my "order" table with
> the customer ID# (which was the "counter" data type) I was OK.  When
> I tried to enter a new order from the same customer the system
> refused.
>
> Thanks for taking the time to help someone "wet behind the ears" and
> designing a database for a school project.
>
> [e-mail]
>> Try setting the "RELATIONSHIP" AS A "ONE TO MANY" . THIS WILL
ALLOW ENTRIES TO BE LOCKED TO THE CUSTOMER DATABASE WITH MULTIPLE
ORDERS PER CUSTOMER
=========================================================================
Date:         Fri, 26 Mar 1993 11:34:46 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      re: setting a starting value for a counter

SQL Support Section (SQS)         Mail [e-mail]
===============================================================

I remembered that someone wondered whther this could be done, well I just
found a file in the access directory called psskb.? and it answers
many questions, one of them is How can I change the starting value of a counter
field to a number other than 1? - its answer is not easy but shows it can be do
ne.
Anne

Thankyou
===============================================================
=========================================================================
Date:         Fri, 26 Mar 1993 11:49:53 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      re: my 75 column table

SQL Support Section (SQS)         Mail [e-mail]
===============================================================

For those interested in these things, I managed to create the definition
for the imput spec from the catalog data stored in SQL/DS. Sadly I couldnt
do it from Access cos I didnt have access to the MS columns or tables tables.

I think we will now generate something which will generate an import spec
to load into access some of the data that we have in SQL/DS. It seems that
we can input data directly into then input spec table. Thanks for the clue.
So we now have an input spec for the input spec table! Its not quite what
I'd hoped, I had hoped that access would do some of the grind for me. But
it is deffinitely feasable.

My database is now > 2Mb (2621440bytes) with just this one table. ie >5500 rows
in 75 columns. Performance is OK especially as there is no Primary Key on it
yet. The load took less than 2minutes. A query to produce a sum grouped against
2 columns takes about 20seconds for all the data. The whole table in SQL/DS
is some 89000 rows! I am not sure yet whether I will try and load the whole lot
in. Downloading it via send/receive takes a bit too long!
and I only have a 30Mb free! ( I think it would need 32Mb)
(current system is a viglen 486dx2 66MHz 8Mb RAM)

Anne

Thankyou
===============================================================
=========================================================================
Date:         Fri, 26 Mar 1993 10:20:34 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         RAM DIMBA <[e-mail]>
Subject:      RE: Help on Split Transactions

Thanks for the people who replied to my question on "Help on Split
Transactions".  Thank you again for suggesting to use Main/Subform
feature.  I changed my database structure and added few more tables
to achieve my tasks.

I found out that It is easier to do lots of things in ACCESS.  I am
yet familiarize myself with ACCESS Basic.

Thanks.

Ram Dimba
[e-mail]
=========================================================================
Date:         Fri, 26 Mar 1993 14:51:57 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Sal Scozzari <[e-mail]>
Subject:      Subscription request

Hello! I would like to subscribe to your recipient list for your
Microsoft Access group.

Please send any information I need to receive the posted articles.

Thank you kindly! :-)

Sal Scozzari

--------------------------------------------------------------------
Sal Scozzari, Bag of Mostly Water        |Internet:     [e-mail]
UI Design, Project Zed                   |UUCP: ...!uunet!aruba!sals
--------------------------------------------------------------------
=========================================================================
Date:         Fri, 26 Mar 1993 16:24:01 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ned Walsh <[e-mail]>
Subject:      Unsubscribe

I don't recall who the list manager is here, so sorry to send this to
everyone...Please unsubscribe me.  I probably subscribed when my ID was
[e-mail] and now it is
[e-mail], so LISTSERV can't find me.

Yours actually,

Ned
=========================================================================
Date:         Fri, 26 Mar 1993 16:43:23 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Subject:      administrative note

Please don't send unsubscribe notices to the list.  A simple REVIEW
ACCESS-L command sent to LISTSERV@INDYCMS would reveal that I am the
list owner.  Administrivia sent to the list is just aggravating to
the subscribers and I am perfectly willing to take care of these things.

Thanks,
Nathan Brindle
Listowner

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 26 Mar 1993 18:30:29 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: setting a starting value for a counter

stats access-l loc
=========================================================================
Date:         Fri, 26 Mar 1993 21:45:01 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark Plutowksi <[e-mail]>
Subject:      Re:  Subscription request

Subscribe by mailing to LISTSERV.
This kind of broadcas is bad news for everyone.

= Mark
=========================================================================
Date:         Fri, 26 Mar 1993 21:47:19 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark Plutowksi <[e-mail]>
Subject:      Re: Comparisons with Paradox & Foxpro

Thanks for the informative reply!

= Mark
=========================================================================
Date:         Sat, 27 Mar 1993 14:02:21 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ned Walsh <[e-mail]>
Subject:      Re: Subscription request
In-Reply-To:  Your message of Fri, 26 Mar 1993 21:45:01 -0800

I am not trying to subscribe.  I am trying to unsubscribe.  My ID
changed since I subscribed, but Columbia's mail router skillfully
reroutes mail addressed to my old address to my new address.  When I
send an unsubscribe request to the LISTSERV I get a message back saying
I am not currently subscribed to ACCESS, as far as it knows, and
mentions that perhaps the situation is exactly as I described--I'm
subscribed under a previous address that has mail being forwarded to my
current address.  The only way to to get off the list, then, is via the
list administrator's intervention.  I do not know who the list
administrator is.  So I write to the list expecting the list
administrator will pick up on the message and see that I get
unsubscribed.  What else do you expect me to do???????  This sort of
message to the list re subscription/unsubscription quirks and problems
is perfectly legitimate and occurs all the time on LISTSERV lists.  It
is your message which is rude, inappropriate, and bad news for
everyone.

/Ned
=========================================================================
Date:         Sat, 27 Mar 1993 14:04:03 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ned Walsh <[e-mail]>
Subject:      Re: Subscription request
In-Reply-To:  Your message of Fri, 26 Mar 1993 21:45:01 -0800

Whoops, that was supposed to go to Mark only, not the whole list.  Now
THAT was a rude, inappropriate, bad news for everyone sort of message.
Mucho mucho mucho apologies to all.  Talk about having egg on one's
face.

Sorry,

Ned
=========================================================================
Date:         Mon, 29 Mar 1993 09:03:05 BST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Anne L Zorner R27.G5/" <[e-mail]>
Subject:      re fox, access, P4W and Superbase

SQL Support Section (SQS)         Mail [e-mail]
===============================================================
For information, when I was at one of the  PC Database days that were done
here in the UK, certain people in Microsoft claimed that eventually Fox Pro
and Access would come closer together. With them both having the same
database engine.

One of the big problems, as I see it, with P4W is that its SQL link (similarly
for Superbase) will not be available for its own database, it
will only be there to access the bigger database systems. For superbase
this access will not (they said) be available through their point and click
standard interface, does anyone know the validity if that statement? and
what about P4W will that have the same problem?

By the way does anyone have any knowledge as what will be the features in
the upgrade to Access that is due later this year?

Regards Anne

Thankyou
===============================================================
=========================================================================
Date:         Mon, 29 Mar 1993 17:49:30 +0200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Center for Security Studies, ETH Zuerich,
              Switzerland" <[e-mail]>
Subject:      How do I print on form-style paper?

I am trying to build a new database for our addresses with ACCESS. Everything
is fine except one problem. I am using an old matrix printer (Brother M-1709)
to print on "endless-type" address labels in one row. But every time I try that
 I get a page break from ACCESS after one (supposed) A4-page. What do I do to
get rid of this page break, which throws my endless labels off track? Is this
an ACCESS-problem, or a windows-printer-driver problem? If so, how do I set
my printer driver to an "infinite" page length?

Any advice would be appreciated

Thomas Koeppel
Zurich Polytech, Switzerland

[e-mail]

Fax: xx41 1 364 00 69
=========================================================================
Date:         Mon, 29 Mar 1993 09:51:33 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Miller <[e-mail]>
Subject:      Problem combining text fields

I have a problem combining multiple fields into a single text box
in a report.

I have three fields in a table - Title, First Name and Last Name.
All three of these are of the "Text" datatype. I want to combine
these fields in a report so that they look like

    Mr. Joe Walker

instead of,

    Mr.     Joe       Walker

I follow the example in the user's guide and use the following as
the source for the text box:

="|[Title]| |[First Name]| |[Last Name]|"

When I preview the report, I get "#Error" in the text box. If I
change the table so that the "Title" field is renamed to "TTitle"
and make the corresponding change in the report, everything works
as expected. If I just use [Title] as the source for a text box,
everything works fine.

Does anybody have any ideas before I try Microsoft customer
support?

Thanks,
Steve

PS - I also have a similar problem with a field named City.


--
+-------------------------------------------------------+
| Steve Miller                   PictureTel Corporation |
| email: [e-mail]       One Corporation Way    |
| phone: [phone]          Peabody, MA 01960      |
+-------------------------------------------------------+
=========================================================================
Date:         Mon, 29 Mar 1993 10:15:57 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Ron Todd <[e-mail]>
Subject:      Re:  Problem combining text fields

        I have a problem combining multiple fields into a single text box
        in a report.

        I have three fields in a table - Title, First Name and Last Name.
        All three of these are of the "Text" datatype. I want to combine
        these fields in a report so that they look like

            Mr. Joe Walker

        instead of,

            Mr.     Joe       Walker

        I follow the example in the user's guide and use the following as
        the source for the text box:

        ="|[Title]| |[First Name]| |[Last Name]|"

I had the same problem in composing a part number from "product type"
"product number" and "product option" as well as composing "product
option" from "option types" and "option number".  What I did was use
string concatination:  the "&" character between components of the
string as well as Format$() to convert the numbers to strings.  A'la

        =[Title]&[First Name]&[Last Name]

But this will not insert spaces between the components so what you
will have to do is add in the literals:

        =[Title]&" "&[First Name]&" "&[Last Name]

For the numbers this is what I ended up with:

        =[product type]&Format$([product number],"")&[product option]

The null string in the Format$() function tells Access to return just
the number without formating; drop leading spaces and don't use leading
zeros or formating characters such as commas or currency symbols.

I have noticed the same error messages in querys involving these fields
but have not had any problems with the resulting data, I am even using
the "part number" as an index in my table and when there is no option
specified, the "product option" component returns a null string.

Ron Todd
=========================================================================
Date:         Mon, 29 Mar 1993 10:38:12 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Miller <[e-mail]>
Subject:      Re:  Problem combining text fields
In-Reply-To:  <[e-mail]>; from "Ron Todd" at Mar
              29, 93 10:15 am

>
>         I have a problem combining multiple fields into a single text box
>         in a report.
>
>         I have three fields in a table - Title, First Name and Last Name.
>         All three of these are of the "Text" datatype. I want to combine
>         these fields in a report so that they look like
>
>             Mr. Joe Walker
>
>         instead of,
>
>             Mr.     Joe       Walker
>
>         I follow the example in the user's guide and use the following as
>         the source for the text box:
>
>         ="|[Title]| |[First Name]| |[Last Name]|"
>
> I had the same problem in composing a part number from "product type"
> "product number" and "product option" as well as composing "product
> option" from "option types" and "option number".  What I did was use
> string concatination:  the "&" character between components of the
> string as well as Format$() to convert the numbers to strings.  A'la
>
>         =[Title]&[First Name]&[Last Name]
>
> But this will not insert spaces between the components so what you
> will have to do is add in the literals:
>
>         =[Title]&" "&[First Name]&" "&[Last Name]
>

I should of mentioned that I tried this approach, too. This is
the way that is suggested in the online help. It didn't work for
me either.

Any more ideas?

--

Steve Miller    x235
=========================================================================
Date:         Mon, 29 Mar 1993 10:40:53 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      RE: fox, access, P4W and Superbase

  >SQL Support Section (SQS)         Mail [e-mail]
  >===============================================================
  >For information, when I was at one of the  PC Database days that were done
  >here in the UK, certain people in Microsoft claimed that eventually Fox Pro
  >and Access would come closer together. With them both having the same
  >database engine.
  >
  >One of the big problems, as I see it, with P4W is that its SQL link (similarl
 y
  >for Superbase) will not be available for its own database, it
  >will only be there to access the bigger database systems. For superbase
  >this access will not (they said) be available through their point and click
  >standard interface, does anyone know the validity if that statement? and
  >what about P4W will that have the same problem?
  >
  >By the way does anyone have any knowledge as what will be the features in
  >the upgrade to Access that is due later this year?
  >
  >Regards Anne
  >
  >Thankyou
  >===============================================================

  I don't know what SQL link Superbase and P4W will provide.
  But I would believe that P4W will provide a SQL interface that will
  work with its database engine and remote database engines.  Using the
  SQL interface, the target database engines should become transparent
  to your applications.

  I would not think that a product like P4W would make you put a logic in your
  applications to determine what database engines are in use and to handle them
  differently.  Borland's IDAPI (Independent Database Application Programming
  Interface) will handle the hard work for you.  I would believe that P4W will
  provide a SQL support that equals to or exceeds what Access currently provides
 .

  Kha Tran


End of returned message
=========================================================================
Date:         Mon, 29 Mar 1993 09:45:22 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         randy legeai <[e-mail]>
Subject:      Re: How do I print on form-style paper?
In-Reply-To:  <[e-mail]>; from "Center for
              Security Studies, ETH Zuerich," at Mar 29, 93 5:49 pm

>
> I am trying to build a new database for our addresses with ACCESS. Everything
> is fine except one problem. I am using an old matrix printer (Brother M-1709)
> to print on "endless-type" address labels in one row. But every time I try
 that
>  I get a page break from ACCESS after one (supposed) A4-page. What do I do to
> get rid of this page break, which throws my endless labels off track? Is this
> an ACCESS-problem, or a windows-printer-driver problem? If so, how do I set
> my printer driver to an "infinite" page length?

I had the identical problem printing single-column labels on my
Panasonic printer.  I called Microsoft, who dutifully checked it out
and told me that it is a function of the Windows printer driver,
mainly that it only "knows" the predetermined page sizes, and
otherwize had no work-around.  I did, however, succeed in getting it
to work, except that it soes not print the last label on the page.
In Print Setup, I set page size to 8.5 x 11.  Left and Top Margins
to 0.25", (others to 0"), Items Across to 1, Row Spacing to 0.06",
Width to 3.5, Height to 0.94.  This is for Avery #4145 type labels,
that are 12 labels to a 'sheet', with each label 3.5" x 15/16".
Let me know if it works!  If so, one of us should post the solution
to the list.
--
Randall Legeai                             [e-mail]
Federal Agency Affairs / Ctr. Bioenv. Research      Phn: 504/865-5758
327 Gibson Hall, Tulane University                  Fax: [phone]
New Orleans, Louisiana 70118-5698
=========================================================================
Date:         Mon, 29 Mar 1993 12:20:37 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Toby Rockwell <[e-mail]>
Subject:      RE: Problem combining text fields

To neatly print names my method has been to create a name in the
query that underlies the reprort.  this will read:

        name:LTrim([title]&" "&[first name]&" "&[last name])

The Ltrim just assures that things are left justified when there is no
title [and first name].  There is still an extra space if there is a
title without first name but I didn't bother putting in the extra level
of LTrim to cure it since it seldom occurs.

With a comma thrown in after the state, this works for the address as well.
=========================================================================
Date:         Mon, 29 Mar 1993 19:53:36 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Miller <[e-mail]>
Subject:      Problem combining text fields (Solution)

You will recall that I sent a message asking about the following
problem.

>
> I have a problem combining multiple fields into a single text box
> in a report.
>
> I have three fields in a table - Title, First Name and Last Name.
> All three of these are of the "Text" datatype. I want to combine
> these fields in a report so that they look like
>
>     Mr. Joe Walker
>
> instead of,
>
>     Mr.     Joe       Walker
>
> I follow the example in the user's guide and use the following as
> the source for the text box:
>
> ="|[Title]| |[First Name]| |[Last Name]|"
>
> When I preview the report, I get "#Error" in the text box. If I
> change the table so that the "Title" field is renamed to "TTitle"
> and make the corresponding change in the report, everything works
> as expected. If I just use [Title] as the source for a text box,
> everything works fine.
>
> Does anybody have any ideas before I try Microsoft customer
> support?
>
> Thanks,
> Steve
>
> PS - I also have a similar problem with a field named City.
>

After poking around in the Access Support forum on CompuServe, I found
the answer to my question. I quote directly (without permission):


      You might have a text box called: [CityStateZip] and its source
      could be the expression:

      =[City] & ", " & [State] & " " & [Zipcode]

      Note that you CANNOT use one of the elements in the expression as
      the NAME of the text box. You could not name the above text box
      [City] for example, or you would get the #Error indication.


Or in my case, I tried to combine a field named [Title] in a text box
named "Title". I simply renamed the text box to "FullName".

--
+-------------------------------------------------------+
| Steve Miller                   PictureTel Corporation |
| email: [e-mail]       One Corporation Way    |
| phone: [phone]          Peabody, MA 01960      |
+-------------------------------------------------------+
=========================================================================
Date:         Mon, 29 Mar 1993 20:13:58 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         George Raudabaugh <[e-mail]>
Subject:      Mouse Dies

I've started banging on Access again and have run into a few problems,
most notably the mouse becoming disabled.  I haven't figured out when/why
this happens yet, but its happened many times (>3), and I was only in the
Table area.

The "workaround" is to make sure I have a DOS session I can ALT-TAB to
and reactivate the mouse driver.  This is a microsoft mouse.

I haven't seen anything here.  I also received an offer package for an
Access specific magazine that included a diskette.  It include a list
of known-bugs but there was nothing about mice.

Any info would be appreciated.

George
--
George Raudabaugh               Manager/Document Technologies
Information Dimensions, Inc.    [e-mail] (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio  43017             [phone]                     (voice mail)
=========================================================================
Date:         Tue, 30 Mar 1993 10:34:44 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pekka Koskinen CIMO <[e-mail]>

>I haven't seen anything here.  I also received an offer package for an
>Access specific magazine that included a diskette.  It include a list
>of known-bugs but there was nothing about mice.
>

Any way to get a copy of that list?

G'day

Pekka

:) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :) :)

    _/_/_/_/   _/   _/_/  _/_/  _/_/_/_/ "How many system administrators does
   _/    _/   _/   _/ _/_/ _/  _/    _/     it take to change a light bulb?
  _/         _/   _/      _/  _/    _/    None -- they just remove the rights
 _/    _/   _/   _/      _/  _/    _/        for people to enter the room."
_/_/_/_/   _/   _/      _/  _/_/_/_/

Pekka Koskinen    tel [phone]    fax [phone]
CIMO, P.O. Box 343, 00531 Helsinki, FINLAND
=========================================================================
Date:         Tue, 30 Mar 1993 13:21:33 +0200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Beat Jaccottet <[e-mail]>
Subject:      ODBC and access to Sybase on a RS/6000

Hi!

I am trying to connect to a Sybase SQL Server (version 4.2) on a RS/6000. I ran
 the scriptfile (INSTCAT.SQL) for defining the required stored procedures on the
 DB, I also tested those SP on the DB, they work fine.

Also the connection from within windows to the Sybase DB works fine (I have a
 tool that checks the connection). When I am trying to reference or include a
 Sybase Table from within Access I get a "general protection violation in
 USER.EXE at 0010:0470" and Access is gone.

Has anyone made similar experiences? Has anyone solved the problem?


Any suggestions or recommandations are greatly appreciated. Thanks in advance!



                - Beat Jaccottet (yes: Beat is my first name...)
=========================================================================
Date:         Tue, 30 Mar 1993 08:16:54 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         randy legeai <[e-mail]>
Subject:      Re: Mouse Dies
In-Reply-To:  <[e-mail]>; from "George Raudabaugh"
              at Mar 29, 93 8:13 pm

>
> I've started banging on Access again and have run into a few problems,
> most notably the mouse becoming disabled.  I haven't figured out when/why
> this happens yet, but its happened many times (>3), and I was only in the
> Table area.
>
> I haven't seen anything here.  I also received an offer package for an
> Access specific magazine that included a diskette.  It include a list
> of known-bugs but there was nothing about mice.

You can download the bug list (and other things)  from Microsoft's
download BBS at 206/936-6735.

--
Randall Legeai                             [e-mail]
Federal Agency Affairs / Ctr. Bioenv. Research      Phn: 504/865-5758
327 Gibson Hall, Tulane University                  Fax: [phone]
New Orleans, Louisiana 70118-5698
=========================================================================
Date:         Tue, 30 Mar 1993 09:24:00 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Michael Gordon <[e-mail]>
Subject:      Re: Mouse Dies

>> I haven't seen anything here.  I also received an offer package for an
>> Access specific magazine that included a diskette.  It include a list
>> of known-bugs but there was nothing about mice.
>
>You can download the bug list (and other things)  from Microsoft's
>download BBS at 206/936-6735.
>
        The bug list is also available somewhere at CICA.

Michael D. Gordon
CIS: 71053,471
Internet: [e-mail]
Date sent:  30-MAR-1993 09:24:07
=========================================================================
Date:         Tue, 30 Mar 1993 17:06:50 MET-1
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Hr. Johannes KREMSNER" <[e-mail]>
Subject:      DB2 with ACCESS

Has anyone an ODBC-driver for DB2 on an IBM-Mainframe?
Special thank's to all who help me with my urgent problem!
+--------------------------------------------------------------------+
|University of Art    |                                              |
|Mr. Johannes Kremsner|                                              |
|Networkadministrator |                                              |
|Hauptplatz 8         |                                              |
|4020 LINZ/AUSTRIA    |                                              |
+--------------------------------------------------------------------+
=========================================================================
Date:         Tue, 30 Mar 1993 12:36:30 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      General Protection Fault in Access

 I came a cross a nasty one!

 Although I didn't isolate the problem completely I suspect it has to do with
 the following setup:
     I am using a query to pick records in a specific date interval and a status
     interval (integers 1...5) from a table of apox 7200 records. The SQL
     statment WHERE clause includes a construct of type
     (cond1 AND ((cond2 AND cond3) OR cond4)).  Everything works fine until I
     try to use format() function to format one of the fields (the date).
     If I add    Date: Format(date, "dd-mmm-yy")   in the date cell of the query
     and run it I get a nasty dialog box:  "MSACCESS:  Your application had
     internal error!  <Close>  <Ignore>"  No metter what button I choose ProgMan
     kicks in with "General Protection Fault" and throughs me out of Access with
     half (!) of system memory still taken!

     This happens consistently and with both format() and format$().  I found a
     work around, but if you've seen something of the same it would be
     interesting to find where exactly this thing bombs.  Plus I heard that
     MicroSoft might be reading this....
=========================================================================
Date:         Tue, 30 Mar 1993 16:00:00 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      numerical string field format

After years of being relatively adept with dBASE I am slowly
learning Access, generally without problem.  However, I have been
stuck for the last week on this and I am running out of time.  I
have been unable to figure out what to do by RTM or Cue Cards,
etc.  I hope someone out there can point me in the right
direction.  Thanks in advance to anyone who responds!


This probably has an outrageously simple answer, but here goes.
I want set the format for a field to have numeric content *ONLY*
- no alphabetical or other characters - *AND* to be of a
specified length; i.e., I need fields that are strings composed
of 5 or 10 numerical digits.  The fields are not to represent
logical numbers but act instead as identifiying code.  I don t
quite seem to be able to specify this in the Design View box. Any
ideas?


Thanks!


Laurin M. Buchanan
Institute of Fine Arts
New York University
bitnet: buchananl@nyuacf
voice: 212.758.3223
fax: [phone]
=========================================================================
Date:         Tue, 30 Mar 1993 16:06:17 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Subject:      Re: numerical string field format
In-Reply-To:  Message of Tue, 30 Mar 1993 16:00:00 EDT from <BUCHANANL@NYUACF>

There isn't a formatting character for a Text field that allows only
numeric input (HELLO MICROSOFT--THIS WOULD BE HANDY).  What it looks like
you'll have to do is write a validation function that is called every time
the field is updated, which checks the string entered to see if each character
is a digit 0-9.  I just checked the online help under FORMAT PROPERTY and
found that you can do what you want to do in a <numeric> field, but not
with a <text> field.

I have had some luck with using formats like "93-0000" in counter fields,
which gives me numbers I can use like 93-0001, 93-0002 for request numbers,
etc.  Not knowing the design of your database, that <might> be one way to
do it.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 30 Mar 1993 17:37:24 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      transfer Excel notes to Access

When importing Excel *.xls files to Access, is it possible to transfer the
Excel note information to Access ?                      Tak Fung
=========================================================================
Date:         Tue, 30 Mar 1993 17:37:50 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "ROBERT GRINNELL,
              SEATTLE PACIFIC UNIVERSITY" <[e-mail]>
Subject:      RE: transfer Excel notes to Access

On Tues, March 30, Tak Fung writes:

>When importing Excel *.xls files to Access, is it possible to transfer the
>Excel note information to Access ?                      Tak Fung

I am not certain, but I don't think it can do so.  It would be difficult
to have programmed Access to deal with the potential ambiguities in
doing this (notes in different cells of the same row/record, etc.).

As a workaround, I would suggest writing a macro in Excel that moves
through all cells containing notes and copies the contents to a new
column/field, which could then be included in the Access import of the
worksheet.  There are a couple of limitations inherent in this
approach, however:

1.  Text in cells is limited to 255 characters; notes can be much longer,
so you would lose anything beyond the first 255.

2.  If you have multiple notes in a row/record, this must be dealt with
somehow.  There are several possible solutions, which I won't take the
time to go into now.

There is another (Excel) macro solution that overcomes these limitations,
relying on Access' relational capabilities, but is more complex, because it
involves writing the notes to a delimited text file and importing it
into Access separately.

If you want more detailed thoughts, or aren't up to writing such a macro,
feel free to contact me directly.  It's an interesting problem, and I
could give it a try.

Robert Grinnell
Seattle Pacific University
[e-mail]
=========================================================================
Date:         Tue, 30 Mar 1993 21:56:16 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dmitry Serebrennikov <[e-mail]>
Subject:      Re: numerical string field format
In-Reply-To:  <[e-mail]> from
              "[e-mail]" at Mar 30,
              93 04:00:00 pm

>
> This probably has an outrageously simple answer, but here goes.
> I want set the format for a field to have numeric content *ONLY*
> - no alphabetical or other characters - *AND* to be of a
> specified length; i.e., I need fields that are strings composed
> of 5 or 10 numerical digits.  The fields are not to represent
> logical numbers but act instead as identifiying code.  I don t
> quite seem to be able to specify this in the Design View box. Any
> ideas?
>
        Depending on how (and when) you want the system to complain if someone
        violates this validation rule there is a simple and a more complicated
        answer.
        A simple:  you can set validation property in the table or the form
        to:
                Like "#########"
        where every # represents a digit.  In case Access considers +-a...f as
        digits (I dought it) you can do  Like "[0-9][0-9][0-9]..." where
        every [0-9] stands for a character between 0 and 9.  In this setup
        you will get a complaint (contents of the Validation Text propery)
        when trying to save the invalid value to the table or when leaving a
        control on the form.
        A complicated way:  someone had suggested it already: attach a function
        to beforeUpdate propery of the control and check every character as
        it is typed in.  This way you can beep at the user as soon as s/he
        makes a mistake.

        Hope this helps.
        The good place to check is:  Access User's Guide p641-656
=========================================================================
Date:         Wed, 31 Mar 1993 14:55:20 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Brian M. Glasgow" <[e-mail]>
Subject:      Re: administrative note

> Date:          Fri, 26 Mar 1993 16:43:23 EST
> Reply-to:      Microsoft Access Database Discussion List
>                <[e-mail]>
> From:          Nathan Brindle <[e-mail]>
> Subject:       administrative note
> To:            Multiple recipients of list ACCESS-L <ACCESS-L%INDYCMS.BitNet@p
 ucc.PRINCETON.EDU>

> Please don't send unsubscribe notices to the list.  A simple REVIEW
> ACCESS-L command sent to LISTSERV@INDYCMS would reveal that I am the
> list owner.  Administrivia sent to the list is just aggravating to
> the subscribers and I am perfectly willing to take care of these things.
>
> Thanks,
> Nathan Brindle
> Listowner
> ------------------------------------------------------------------------------
>>>  You failed to mention how one is SUPPOSED to subscribe/unsub.
=========================================================================
Date:         Wed, 31 Mar 1993 16:11:05 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Subject:      Re: administrative note
In-Reply-To:  Message of Wed,
              31 Mar 1993 14:55:20 CST from <[e-mail].M ISSOURI.EDU>

The reason I did not mention how to unsubscribe is because the information
is contained in the "boilerplate" message that is sent to you by LISTSERV
when you subscribe.  However, for those who don't read such things,

UNSUB ACCESS-L

sent to [e-mail] will unsubscribe you.

If you send the command INFO REFCARD to [e-mail], the
listserver will send back a "reference card" of LISTSERV commands.

Nathan Brindle
Listowner

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Owner, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet:    [e-mail] or [e-mail]
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 31 Mar 1993 21:02:42 GMT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Adams <[e-mail]>
Subject:      Re: numerical string field format

> >
> > This probably has an outrageously simple answer, but here goes.
> > I want set the format for a field to have numeric content *ONLY*
> > - no alphabetical or other characters - *AND* to be of a
> > specified length; i.e., I need fields that are strings composed
> > of 5 or 10 numerical digits.  The fields are not to represent
> > logical numbers but act instead as identifiying code.  I don t
> > quite seem to be able to specify this in the Design View box. Any
> > ideas?
> >
>         Depending on how (and when) you want the system to complain if someone
>         violates this validation rule there is a simple and a more complicated
>         answer.
 < stuff removed >
>         A complicated way:  someone had suggested it already: attach a
 function
>         to beforeUpdate propery of the control and check every character as
>         it is typed in.  This way you can beep at the user as soon as s/he
>         makes a mistake.

But this won't check each character as it is typed - the beforeUpdate
property is used after the user attempts to update the value in the field
(by pressing ENTER, or TAB or clicking on another field for example).  It
certainly could check each digit, but not as it is typed.  You could check
the number string thus:
   for i = 1 to len(field_name)
      if not isnumber(mid$(field_name,i,1)) then
         msgbox "Digit " & trim$(str$(i)) & " is not a number", 64
         exit function
      endif
   endfor
or somesuch.


David Adams, Data Strike Computers Ltd.
=========================================================================
Date:         Wed, 31 Mar 1993 16:29:22 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jennifer Spielberger <[e-mail]>
Subject:      foxbase/pro

Hello!

I am not a subscriber to this list, so if you have any words of wisdom,
please reply directly to me...

I'm looking for a list for FoxBase / FoxPro users and developers.  Does
ayone know if such a list exists?

Thanks in advance for any help you can offer!!

+------------------------+----------------------------+---------------------+
| Jennifer Spielberger   | [e-mail]     | [phone] x478  |
| Information Analyst    +--------------------------------------------------+
| Wheaton College        | "See here how everything leads up to this day    |
| East Main Street       |   And its just like any other day that's         |
| Norton, MA 02766       |      Ever been."        Jerry                    |
+------------------------+--------------------------------------------------
+